home *** CD-ROM | disk | FTP | other *** search
| AllFusion ERwin data | 1997-12-17 | 131.7 KB |
open in: 
MacOS 8.1
|
Win98
|
DOS
view JSON data
|
view as text
This file was processed as: AllFusion ERwin data
(other/allFusionERwinData).
This format is not currently supported by dexvert.
| Confidence | Program | Detection | Match Type | Support
|
|---|
| 1%
| dexvert
| AllFusion ERwin data (other/allFusionERwinData)
| magic
| Unsupported |
| 100%
| file
| data
| default
| |
| 100%
| TrID
| AllFusion ERwin data
| default
| |
| 100%
| gt2
| Kopftext: 'V2.40 ERwi'
| default (weak)
|
|
hex view+--------+-------------------------+-------------------------+--------+--------+
|00000000| 56 32 2e 34 30 20 45 52 | 77 69 00 00 00 00 ac c2 |V2.40 ER|wi......|
|00000010| 00 00 b4 c2 00 00 01 00 | 00 00 01 00 00 00 00 00 |........|........|
|00000020| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000030| 00 00 01 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000040| 00 00 00 00 00 00 01 00 | 00 00 15 00 00 00 00 00 |........|........|
|00000050| 01 00 00 00 00 00 00 00 | bc 00 00 00 5b 1b 00 00 |........|....[...|
|00000060| 00 00 00 00 19 00 08 00 | 09 00 00 00 00 00 00 00 |........|........|
|00000070| 00 00 00 00 07 00 00 00 | 01 00 00 00 00 00 00 00 |........|........|
|00000080| 00 00 00 00 02 10 40 00 | 32 00 00 00 28 c3 00 00 |......@.|2...(...|
|00000090| 14 00 00 00 b0 c2 00 00 | 28 00 00 00 00 00 00 00 |........|(.......|
|000000a0| 0a 00 08 00 43 48 41 52 | 28 31 38 29 00 00 00 00 |....CHAR|(18)....|
|000000b0| 00 00 00 00 00 00 13 00 | 58 25 4b 65 79 54 79 70 |........|X%KeyTyp|
|000000c0| 65 25 54 61 62 6c 65 4e | 61 6d 65 00 00 00 00 00 |e%TableN|ame.....|
|000000d0| 00 00 00 00 00 00 00 02 | 00 00 00 00 00 07 00 4e |........|.......N|
|000000e0| 6f 74 65 20 49 44 ff ff | 00 00 00 01 00 09 00 4e |ote ID..|.......N|
|000000f0| 6f 74 65 20 54 65 78 74 | ff ff 00 00 00 00 00 00 |ote Text|........|
|00000100| 00 0c 00 00 00 01 00 00 | 00 19 00 00 00 00 01 00 |........|........|
|00000110| 00 00 1a 00 00 00 00 01 | 00 00 00 00 00 00 00 00 |........|........|
|00000120| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 14 00 00 |........|........|
|00000130| 00 00 02 00 00 00 1a 00 | 00 00 00 02 00 00 00 00 |........|........|
|00000140| 00 00 00 00 04 00 00 00 | 00 00 00 00 00 01 00 00 |........|........|
|00000150| 00 00 00 00 00 00 01 00 | 00 00 00 00 00 00 00 01 |........|........|
|00000160| 00 00 00 00 00 00 00 00 | 02 00 00 00 00 00 00 00 |........|........|
|00000170| 00 13 00 00 00 0c 00 00 | 00 0b 00 56 41 4c 49 44 |........|...VALID|
|00000180| 5f 52 55 4c 45 31 0d 00 | 44 69 73 63 6f 75 6e 74 |_RULE1..|Discount|
|00000190| 20 3e 3d 20 30 00 00 00 | 00 00 00 00 00 81 00 00 | >= 0...|........|
|000001a0| 00 00 00 00 00 00 00 00 | 00 00 00 2b 00 25 41 74 |........|...+.%At|
|000001b0| 74 46 69 65 6c 64 4e 61 | 6d 65 20 6d 75 73 74 20 |tFieldNa|me must |
|000001c0| 62 65 20 67 72 65 61 74 | 65 72 20 6f 72 20 65 71 |be great|er or eq|
|000001d0| 75 61 6c 20 74 6f 20 30 | 00 00 00 00 0c 00 00 00 |ual to 0|........|
|000001e0| 0c 00 56 41 4c 49 44 5f | 52 55 4c 45 31 30 52 00 |..VALID_|RULE10R.|
|000001f0| 4e 4f 54 20 28 43 41 4e | 2d 46 49 4e 44 28 46 49 |NOT (CAN|-FIND(FI|
|00000200| 52 53 54 20 43 75 73 74 | 6f 6d 65 72 20 57 48 45 |RST Cust|omer WHE|
|00000210| 52 45 20 43 75 73 74 6f | 6d 65 72 2e 43 6f 75 6e |RE Custo|mer.Coun|
|00000220| 74 72 79 20 3d 20 0d 0a | 20 20 20 4c 6f 63 61 6c |try = ..| Local|
|00000230| 2d 44 65 66 61 75 6c 74 | 2e 43 6f 75 6e 74 72 79 |-Default|.Country|
|00000240| 29 29 00 00 00 00 00 00 | 00 00 85 00 00 00 00 00 |))......|........|
|00000250| 00 00 00 00 00 00 00 00 | 46 00 54 68 69 73 20 72 |........|F.This r|
|00000260| 65 63 6f 72 64 20 63 61 | 6e 6e 6f 74 20 62 65 20 |ecord ca|nnot be |
|00000270| 64 65 6c 65 74 65 64 20 | 69 66 20 75 73 65 64 20 |deleted |if used |
|00000280| 69 6e 20 61 74 20 6c 65 | 61 73 74 20 6f 6e 65 20 |in at le|ast one |
|00000290| 43 75 73 74 6f 6d 65 72 | 20 72 65 63 6f 72 64 2e |Customer| record.|
|000002a0| 00 00 00 00 0c 00 00 00 | 0c 00 56 41 4c 49 44 5f |........|..VALID_|
|000002b0| 52 55 4c 45 31 31 1b 00 | 43 41 4e 2d 46 49 4e 44 |RULE11..|CAN-FIND|
|000002c0| 28 63 75 73 74 6f 6d 65 | 72 20 4f 46 20 6f 72 64 |(custome|r OF ord|
|000002d0| 65 72 29 00 00 00 00 00 | 00 00 00 81 00 00 00 00 |er).....|........|
|000002e0| 00 00 00 00 00 00 00 00 | 00 1b 00 43 75 73 74 6f |........|...Custo|
|000002f0| 6d 65 72 20 6d 75 73 74 | 20 61 6c 72 65 61 64 79 |mer must| already|
|00000300| 20 65 78 69 73 74 00 00 | 00 00 0c 00 00 00 0c 00 | exist..|........|
|00000310| 56 41 4c 49 44 5f 52 55 | 4c 45 31 32 0d 00 6f 72 |VALID_RU|LE12..or|
|00000320| 64 65 72 2d 6e 75 6d 20 | 3e 20 30 00 00 00 00 00 |der-num |> 0.....|
|00000330| 00 00 00 81 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000340| 00 26 00 4f 72 64 65 72 | 20 6e 75 6d 62 65 72 20 |.&.Order| number |
|00000350| 6d 75 73 74 20 62 65 20 | 67 72 65 61 74 65 72 20 |must be |greater |
|00000360| 74 68 61 6e 20 7a 65 72 | 6f 00 00 00 00 0c 00 00 |than zer|o.......|
|00000370| 00 0c 00 56 41 4c 49 44 | 5f 52 55 4c 45 31 33 05 |...VALID|_RULE13.|
|00000380| 00 31 20 3d 20 31 00 00 | 00 00 00 00 00 00 85 00 |.1 = 1..|........|
|00000390| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000003a0| 00 00 0c 00 00 00 0c 00 | 56 41 4c 49 44 5f 52 55 |........|VALID_RU|
|000003b0| 4c 45 31 34 1c 00 43 41 | 4e 2d 46 49 4e 44 28 69 |LE14..CA|N-FIND(i|
|000003c0| 74 65 6d 20 4f 46 20 6f | 72 64 65 72 2d 6c 69 6e |tem OF o|rder-lin|
|000003d0| 65 29 00 00 00 00 00 00 | 00 00 81 00 00 00 00 00 |e)......|........|
|000003e0| 00 00 00 00 00 00 00 00 | 14 00 49 74 65 6d 20 6d |........|..Item m|
|000003f0| 75 73 74 20 62 65 20 6f | 6e 20 66 69 6c 65 00 00 |ust be o|n file..|
|00000400| 00 00 0c 00 00 00 0c 00 | 56 41 4c 49 44 5f 52 55 |........|VALID_RU|
|00000410| 4c 45 31 35 1d 00 43 41 | 4e 2d 46 49 4e 44 28 6f |LE15..CA|N-FIND(o|
|00000420| 72 64 65 72 20 4f 46 20 | 6f 72 64 65 72 2d 6c 69 |rder OF |order-li|
|00000430| 6e 65 29 00 00 00 00 00 | 00 00 00 81 00 00 00 00 |ne).....|........|
|00000440| 00 00 00 00 00 00 00 00 | 00 10 00 4f 72 64 65 72 |........|...Order|
|00000450| 20 6d 75 73 74 20 65 78 | 69 73 74 00 00 00 00 0c | must ex|ist.....|
|00000460| 00 00 00 0c 00 56 41 4c | 49 44 5f 52 55 4c 45 31 |.....VAL|ID_RULE1|
|00000470| 36 0c 00 63 75 73 74 2d | 6e 75 6d 20 3e 20 30 00 |6..cust-|num > 0.|
|00000480| 00 00 00 00 00 00 00 81 | 00 00 00 00 00 00 00 00 |........|........|
|00000490| 00 00 00 00 00 29 00 43 | 75 73 74 6f 6d 65 72 20 |.....).C|ustomer |
|000004a0| 6e 75 6d 62 65 72 20 6d | 75 73 74 20 62 65 20 67 |number m|ust be g|
|000004b0| 72 65 61 74 65 72 20 74 | 68 61 6e 20 7a 65 72 6f |reater t|han zero|
|000004c0| 00 00 00 00 0c 00 00 00 | 0c 00 56 41 4c 49 44 5f |........|..VALID_|
|000004d0| 52 55 4c 45 31 37 28 00 | 4e 4f 54 20 43 41 4e 2d |RULE17(.|NOT CAN-|
|000004e0| 46 49 4e 44 28 46 49 52 | 53 54 20 43 75 73 74 6f |FIND(FIR|ST Custo|
|000004f0| 6d 65 72 20 4f 66 20 53 | 61 6c 65 73 72 65 70 29 |mer Of S|alesrep)|
|00000500| 00 00 00 00 00 00 00 00 | 85 00 00 00 00 00 00 00 |........|........|
|00000510| 00 00 00 00 00 00 36 00 | 43 61 6e 6e 6f 74 20 64 |......6.|Cannot d|
|00000520| 65 6c 65 74 65 20 69 66 | 20 75 73 65 64 20 69 6e |elete if| used in|
|00000530| 20 6f 6e 65 20 6f 72 20 | 6d 6f 72 65 20 63 75 73 | one or |more cus|
|00000540| 74 6f 6d 65 72 20 72 65 | 63 6f 72 64 73 2e 00 00 |tomer re|cords...|
|00000550| 00 00 0c 00 00 00 0c 00 | 56 41 4c 49 44 5f 52 55 |........|VALID_RU|
|00000560| 4c 45 31 38 27 00 4e 4f | 54 20 28 43 41 4e 2d 46 |LE18'.NO|T (CAN-F|
|00000570| 49 4e 44 28 46 49 52 53 | 54 20 63 75 73 74 6f 6d |IND(FIRS|T custom|
|00000580| 65 72 20 4f 46 20 73 74 | 61 74 65 29 29 00 00 00 |er OF st|ate))...|
|00000590| 00 00 00 00 00 85 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000005a0| 00 00 00 3a 00 54 68 69 | 73 20 73 74 61 74 65 20 |...:.Thi|s state |
|000005b0| 72 65 63 6f 72 64 20 69 | 73 20 75 73 65 64 20 62 |record i|s used b|
|000005c0| 79 20 61 74 20 6c 65 61 | 73 74 20 6f 6e 65 20 43 |y at lea|st one C|
|000005d0| 75 73 74 6f 6d 65 72 20 | 72 65 63 6f 72 64 2e 00 |ustomer |record..|
|000005e0| 00 00 00 0c 00 00 00 0b | 00 56 41 4c 49 44 5f 52 |........|.VALID_R|
|000005f0| 55 4c 45 32 2d 00 43 72 | 65 64 69 74 2d 4c 69 6d |ULE2-.Cr|edit-Lim|
|00000600| 69 74 20 3e 3d 20 30 20 | 41 4e 44 20 43 72 65 64 |it >= 0 |AND Cred|
|00000610| 69 74 2d 4c 69 6d 69 74 | 20 3c 3d 20 39 39 39 39 |it-Limit| <= 9999|
|00000620| 39 39 39 00 00 00 00 00 | 00 00 00 81 00 00 00 00 |999.....|........|
|00000630| 00 00 00 00 00 00 00 00 | 00 2a 00 43 72 65 64 69 |........|.*.Credi|
|00000640| 74 20 4c 69 6d 69 74 20 | 6d 75 73 74 20 62 65 20 |t Limit |must be |
|00000650| 3e 3d 20 30 20 61 6e 64 | 20 3c 3d 20 39 2c 39 39 |>= 0 and| <= 9,99|
|00000660| 39 2c 39 39 39 00 00 00 | 00 0c 00 00 00 0b 00 56 |9,999...|.......V|
|00000670| 41 4c 49 44 5f 52 55 4c | 45 33 1e 00 43 41 4e 2d |ALID_RUL|E3..CAN-|
|00000680| 46 49 4e 44 28 53 61 6c | 65 73 72 65 70 20 4f 46 |FIND(Sal|esrep OF|
|00000690| 20 43 75 73 74 6f 6d 65 | 72 29 00 00 00 00 00 00 | Custome|r)......|
|000006a0| 00 00 81 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000006b0| 45 00 54 68 65 20 53 61 | 6c 65 73 20 52 65 70 27 |E.The Sa|les Rep'|
|000006c0| 73 20 6e 61 6d 65 20 79 | 6f 75 27 76 65 20 65 6e |s name y|ou've en|
|000006d0| 74 65 72 65 64 20 6d 75 | 73 74 20 65 78 69 73 74 |tered mu|st exist|
|000006e0| 20 69 6e 20 74 68 65 20 | 53 61 6c 65 73 72 65 70 | in the |Salesrep|
|000006f0| 20 74 61 62 6c 65 2e 00 | 00 00 00 0c 00 00 00 0b | table..|........|
|00000700| 00 56 41 4c 49 44 5f 52 | 55 4c 45 34 0c 00 63 75 |.VALID_R|ULE4..cu|
|00000710| 73 74 2d 6e 75 6d 20 3e | 20 30 00 00 00 00 00 00 |st-num >| 0......|
|00000720| 00 00 81 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000730| 29 00 43 75 73 74 6f 6d | 65 72 20 6e 75 6d 62 65 |).Custom|er numbe|
|00000740| 72 20 6d 75 73 74 20 62 | 65 20 67 72 65 61 74 65 |r must b|e greate|
|00000750| 72 20 74 68 61 6e 20 7a | 65 72 6f 00 00 00 00 0c |r than z|ero.....|
|00000760| 00 00 00 0b 00 56 41 4c | 49 44 5f 52 55 4c 45 35 |.....VAL|ID_RULE5|
|00000770| 00 00 00 00 00 00 00 00 | 00 00 81 00 00 00 00 00 |........|........|
|00000780| 00 00 00 00 00 00 00 00 | 2d 00 54 68 65 20 4f 72 |........|-.The Or|
|00000790| 64 65 72 20 6e 75 6d 62 | 65 72 20 65 6e 74 65 72 |der numb|er enter|
|000007a0| 65 64 20 6d 75 73 74 20 | 62 65 20 61 20 76 61 6c |ed must |be a val|
|000007b0| 69 64 20 6f 6e 65 2e 00 | 00 00 00 0c 00 00 00 0b |id one..|........|
|000007c0| 00 56 41 4c 49 44 5f 52 | 55 4c 45 36 1d 00 43 41 |.VALID_R|ULE6..CA|
|000007d0| 4e 2d 46 49 4e 44 28 63 | 75 73 74 6f 6d 65 72 20 |N-FIND(c|ustomer |
|000007e0| 4f 46 20 69 6e 76 6f 69 | 63 65 29 00 00 00 00 00 |OF invoi|ce).....|
|000007f0| 00 00 00 81 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000800| 00 30 00 54 68 65 20 43 | 75 73 74 6f 6d 65 72 20 |.0.The C|ustomer |
|00000810| 6e 75 6d 62 65 72 20 65 | 6e 74 65 72 65 64 20 6d |number e|ntered m|
|00000820| 75 73 74 20 62 65 20 61 | 20 76 61 6c 69 64 20 6f |ust be a| valid o|
|00000830| 6e 65 2e 00 00 00 00 0c | 00 00 00 0b 00 56 41 4c |ne......|.....VAL|
|00000840| 49 44 5f 52 55 4c 45 37 | 0f 00 69 6e 76 6f 69 63 |ID_RULE7|..invoic|
|00000850| 65 2d 6e 75 6d 20 3e 20 | 30 00 00 00 00 00 00 00 |e-num > |0.......|
|00000860| 00 81 00 00 00 00 00 00 | 00 00 00 00 00 00 00 1d |........|........|
|00000870| 00 49 6e 76 6f 69 63 65 | 20 6e 75 6d 62 65 72 20 |.Invoice| number |
|00000880| 63 61 6e 6e 6f 74 20 62 | 65 20 7a 65 72 6f 00 00 |cannot b|e zero..|
|00000890| 00 00 0c 00 00 00 0b 00 | 56 41 4c 49 44 5f 52 55 |........|VALID_RU|
|000008a0| 4c 45 38 0d 00 69 74 65 | 6d 2d 6e 75 6d 20 3e 3d |LE8..ite|m-num >=|
|000008b0| 20 30 00 00 00 00 00 00 | 00 00 81 00 00 00 00 00 | 0......|........|
|000008c0| 00 00 00 00 00 00 00 00 | 29 00 49 74 65 6d 20 6e |........|).Item n|
|000008d0| 75 6d 62 65 72 20 6d 75 | 73 74 20 62 65 20 67 72 |umber mu|st be gr|
|000008e0| 65 61 74 65 72 20 6f 72 | 20 65 71 75 61 6c 20 74 |eater or| equal t|
|000008f0| 6f 20 30 00 00 00 00 0c | 00 00 00 0b 00 56 41 4c |o 0.....|.....VAL|
|00000900| 49 44 5f 52 55 4c 45 39 | 28 00 4e 4f 54 20 28 43 |ID_RULE9|(.NOT (C|
|00000910| 41 4e 2d 46 49 4e 44 28 | 46 49 52 53 54 20 6f 72 |AN-FIND(|FIRST or|
|00000920| 64 65 72 2d 6c 69 6e 65 | 20 4f 46 20 69 74 65 6d |der-line| OF item|
|00000930| 29 29 00 00 00 00 00 00 | 00 00 85 00 00 00 00 00 |))......|........|
|00000940| 00 00 00 00 00 00 00 00 | 3b 00 43 61 6e 6e 6f 74 |........|;.Cannot|
|00000950| 20 64 65 6c 65 74 65 20 | 49 74 65 6d 2c 20 6f 72 | delete |Item, or|
|00000960| 64 65 72 2d 6c 69 6e 65 | 20 72 65 63 6f 72 64 73 |der-line| records|
|00000970| 20 65 78 69 73 74 20 77 | 69 74 68 20 74 68 69 73 | exist w|ith this|
|00000980| 20 69 74 65 6d 00 00 00 | 00 00 00 00 00 08 00 00 | item...|........|
|00000990| 00 01 00 00 00 1e 00 00 | 00 00 01 00 00 00 32 00 |........|......2.|
|000009a0| 00 00 00 01 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000009b0| 00 00 00 00 00 02 00 00 | 00 00 00 00 00 00 04 00 |........|........|
|000009c0| 00 00 00 00 00 00 00 04 | 00 00 00 00 00 00 00 00 |........|........|
|000009d0| 02 00 00 00 00 00 00 00 | 00 0d 00 00 00 08 00 00 |........|........|
|000009e0| 00 08 00 44 45 46 41 55 | 4c 54 5f 00 00 00 00 01 |...DEFAU|LT_.....|
|000009f0| 00 00 00 00 00 00 00 00 | 00 00 00 08 00 00 00 09 |........|........|
|00000a00| 00 44 45 46 41 55 4c 54 | 5f 30 01 00 30 00 00 01 |.DEFAULT|_0..0...|
|00000a10| 00 00 00 00 00 00 00 00 | 00 00 00 08 00 00 00 0c |........|........|
|00000a20| 00 44 45 46 41 55 4c 54 | 5f 31 35 30 30 04 00 31 |.DEFAULT|_1500..1|
|00000a30| 35 30 30 00 00 01 00 00 | 00 00 00 00 00 00 00 00 |500.....|........|
|00000a40| 00 08 00 00 00 0b 00 44 | 45 46 41 55 4c 54 5f 4d |.......D|EFAULT_M|
|00000a50| 44 59 03 00 4d 44 59 00 | 00 01 00 00 00 00 00 00 |DY..MDY.|........|
|00000a60| 00 00 00 00 00 08 00 00 | 00 0d 00 44 45 46 41 55 |........|...DEFAU|
|00000a70| 4c 54 5f 4e 65 74 33 30 | 05 00 4e 65 74 33 30 00 |LT_Net30|..Net30.|
|00000a80| 00 01 00 00 00 00 00 00 | 00 00 00 00 00 08 00 00 |........|........|
|00000a90| 00 0a 00 44 45 46 41 55 | 4c 54 5f 6e 6f 02 00 6e |...DEFAU|LT_no..n|
|00000aa0| 6f 00 00 01 00 00 00 00 | 00 00 00 00 00 00 00 08 |o.......|........|
|00000ab0| 00 00 00 0d 00 44 45 46 | 41 55 4c 54 5f 54 4f 44 |.....DEF|AULT_TOD|
|00000ac0| 41 59 05 00 54 4f 44 41 | 59 00 00 01 00 00 00 00 |AY..TODA|Y.......|
|00000ad0| 00 00 00 00 00 00 00 08 | 00 00 00 0b 00 44 45 46 |........|.....DEF|
|00000ae0| 41 55 4c 54 5f 55 53 41 | 03 00 55 53 41 00 00 01 |AULT_USA|..USA...|
|00000af0| 00 00 00 00 00 00 00 00 | 00 00 00 08 00 00 00 10 |........|........|
|00000b00| 00 46 69 6c 6c 20 57 69 | 74 68 20 53 70 61 63 65 |.Fill Wi|th Space|
|00000b10| 73 00 00 06 00 73 70 61 | 63 65 73 00 00 00 00 00 |s....spa|ces.....|
|00000b20| 00 00 00 00 00 00 00 08 | 00 00 00 13 00 53 65 74 |........|.....Set|
|00000b30| 20 54 6f 20 45 6d 70 74 | 79 20 53 74 72 69 6e 67 | To Empt|y String|
|00000b40| 00 00 05 00 65 6d 70 74 | 79 00 00 00 00 00 00 00 |....empt|y.......|
|00000b50| 00 00 00 00 00 08 00 00 | 00 0b 00 53 65 74 20 54 |........|...Set T|
|00000b60| 6f 20 4e 75 6c 6c 00 00 | 04 00 6e 75 6c 6c 00 00 |o Null..|..null..|
|00000b70| 00 00 00 00 00 00 00 00 | 00 00 08 00 00 00 0b 00 |........|........|
|00000b80| 53 65 74 20 54 6f 20 5a | 65 72 6f 00 00 01 00 30 |Set To Z|ero....0|
|00000b90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ba0| 00 00 05 00 00 00 01 00 | 0d 00 54 65 6d 70 6c 61 |........|..Templa|
|00000bb0| 74 65 20 4e 61 6d 65 22 | 00 00 00 00 01 00 0d 00 |te Name"|........|
|00000bc0| 54 65 6d 70 6c 61 74 65 | 20 43 6f 64 65 00 00 00 |Template| Code...|
|00000bd0| 00 00 00 00 0d 00 54 65 | 6d 70 6c 61 74 65 20 54 |......Te|mplate T|
|00000be0| 79 70 65 00 00 00 00 00 | 00 00 0f 00 54 65 6d 70 |ype.....|....Temp|
|00000bf0| 6c 61 74 65 20 43 53 58 | 20 49 64 00 00 00 00 00 |late CSX| Id.....|
|00000c00| 02 00 00 00 00 00 00 00 | 00 64 00 00 00 05 00 00 |........|.d......|
|00000c10| 00 16 00 50 41 52 45 4e | 54 20 55 50 44 41 54 45 |...PAREN|T UPDATE|
|00000c20| 20 52 45 53 54 52 49 43 | 54 dc 01 20 20 2f 2a 20 | RESTRIC|T.. /* |
|00000c30| 45 52 77 69 6e 20 42 75 | 69 6c 74 69 6e 20 25 44 |ERwin Bu|iltin %D|
|00000c40| 61 74 65 74 69 6d 65 20 | 2a 2f 0d 0a 20 20 2f 2a |atetime |*/.. /*|
|00000c50| 20 25 50 61 72 65 6e 74 | 20 25 56 65 72 62 50 68 | %Parent| %VerbPh|
|00000c60| 72 61 73 65 20 25 43 68 | 69 6c 64 20 4f 4e 20 50 |rase %Ch|ild ON P|
|00000c70| 41 52 45 4e 54 20 55 50 | 44 41 54 45 20 52 45 53 |ARENT UP|DATE RES|
|00000c80| 54 52 49 43 54 20 2a 2f | 0d 0a 20 20 49 46 0d 0a |TRICT */|.. IF..|
|00000c90| 20 20 20 20 2f 2a 20 25 | 25 4a 6f 69 6e 50 4b 50 | /* %|%JoinPKP|
|00000ca0| 4b 28 64 65 6c 65 74 65 | 64 2c 69 6e 73 65 72 74 |K(delete|d,insert|
|00000cb0| 65 64 2c 22 20 3c 3e 20 | 22 2c 22 20 6f 72 20 22 |ed," <> |"," or "|
|00000cc0| 29 20 2a 2f 0d 0a 20 20 | 20 20 25 4a 6f 69 6e 50 |) */.. | %JoinP|
|00000cd0| 4b 50 4b 28 64 65 6c 65 | 74 65 64 2c 69 6e 73 65 |KPK(dele|ted,inse|
|00000ce0| 72 74 65 64 2c 22 20 3c | 3e 20 22 2c 22 20 6f 72 |rted," <|> "," or|
|00000cf0| 20 22 29 0d 0a 20 20 54 | 48 45 4e 20 44 4f 3a 0d | ").. T|HEN DO:.|
|00000d00| 0a 20 20 20 20 49 46 20 | 43 41 4e 2d 46 49 4e 44 |. IF |CAN-FIND|
|00000d10| 28 46 49 52 53 54 20 25 | 43 68 69 6c 64 20 57 48 |(FIRST %|Child WH|
|00000d20| 45 52 45 0d 0a 20 20 20 | 20 20 20 20 20 2f 2a 20 |ERE.. | /* |
|00000d30| 20 25 25 4a 6f 69 6e 46 | 4b 50 4b 28 25 43 68 69 | %%JoinF|KPK(%Chi|
|00000d40| 6c 64 2c 64 65 6c 65 74 | 65 64 2c 22 20 3d 20 22 |ld,delet|ed," = "|
|00000d50| 2c 22 20 61 6e 64 22 29 | 20 2a 2f 0d 0a 20 20 20 |," and")| */.. |
|00000d60| 20 20 20 20 20 25 4a 6f | 69 6e 46 4b 50 4b 28 25 | %Jo|inFKPK(%|
|00000d70| 43 68 69 6c 64 2c 64 65 | 6c 65 74 65 64 2c 22 20 |Child,de|leted," |
|00000d80| 3d 20 22 2c 22 20 61 6e | 64 22 29 29 0d 0a 20 20 |= "," an|d")).. |
|00000d90| 20 20 54 48 45 4e 20 44 | 4f 3a 20 0d 0a 20 20 20 | THEN D|O: .. |
|00000da0| 20 20 20 4d 45 53 53 41 | 47 45 20 22 43 61 6e 6e | MESSA|GE "Cann|
|00000db0| 6f 74 20 55 50 44 41 54 | 45 20 27 25 50 61 72 65 |ot UPDAT|E '%Pare|
|00000dc0| 6e 74 27 20 62 65 63 61 | 75 73 65 20 27 25 43 68 |nt' beca|use '%Ch|
|00000dd0| 69 6c 64 27 20 65 78 69 | 73 74 73 2e 22 2e 0d 0a |ild' exi|sts."...|
|00000de0| 20 20 20 20 20 20 52 45 | 54 55 52 4e 20 45 52 52 | RE|TURN ERR|
|00000df0| 4f 52 2e 0d 0a 20 20 20 | 20 45 4e 44 2e 0d 0a 20 |OR... | END... |
|00000e00| 20 45 4e 44 2e 0d 0a 10 | 27 00 00 00 00 00 00 00 | END....|'.......|
|00000e10| 00 00 00 05 00 00 00 15 | 00 50 41 52 45 4e 54 20 |........|.PARENT |
|00000e20| 55 50 44 41 54 45 20 43 | 41 53 43 41 44 45 d3 01 |UPDATE C|ASCADE..|
|00000e30| 20 20 2f 2a 20 45 52 77 | 69 6e 20 42 75 69 6c 74 | /* ERw|in Built|
|00000e40| 69 6e 20 25 44 61 74 65 | 74 69 6d 65 20 2a 2f 0d |in %Date|time */.|
|00000e50| 0a 20 20 2f 2a 20 25 50 | 61 72 65 6e 74 20 25 56 |. /* %P|arent %V|
|00000e60| 65 72 62 50 68 72 61 73 | 65 20 25 43 68 69 6c 64 |erbPhras|e %Child|
|00000e70| 20 4f 4e 20 50 41 52 45 | 4e 54 20 55 50 44 41 54 | ON PARE|NT UPDAT|
|00000e80| 45 20 43 41 53 43 41 44 | 45 20 2a 2f 0d 0a 20 20 |E CASCAD|E */.. |
|00000e90| 49 46 0d 0a 20 20 20 20 | 2f 2a 20 25 25 4a 6f 69 |IF.. |/* %%Joi|
|00000ea0| 6e 50 4b 50 4b 28 64 65 | 6c 65 74 65 64 2c 69 6e |nPKPK(de|leted,in|
|00000eb0| 73 65 72 74 65 64 2c 22 | 20 3c 3e 20 22 2c 22 20 |serted,"| <> "," |
|00000ec0| 6f 72 20 22 29 20 2a 2f | 0d 0a 20 20 20 20 25 4a |or ") */|.. %J|
|00000ed0| 6f 69 6e 50 4b 50 4b 28 | 64 65 6c 65 74 65 64 2c |oinPKPK(|deleted,|
|00000ee0| 69 6e 73 65 72 74 65 64 | 2c 22 20 3c 3e 20 22 2c |inserted|," <> ",|
|00000ef0| 22 20 6f 72 20 22 29 0d | 0a 20 20 54 48 45 4e 20 |" or ").|. THEN |
|00000f00| 44 4f 3a 0d 0a 20 20 20 | 20 46 4f 52 20 45 41 43 |DO:.. | FOR EAC|
|00000f10| 48 20 25 43 68 69 6c 64 | 20 57 48 45 52 45 0d 0a |H %Child| WHERE..|
|00000f20| 20 20 20 20 20 20 2f 2a | 20 20 25 25 4a 6f 69 6e | /*| %%Join|
|00000f30| 46 4b 50 4b 28 25 43 68 | 69 6c 64 2c 64 65 6c 65 |FKPK(%Ch|ild,dele|
|00000f40| 74 65 64 2c 22 20 3d 20 | 22 2c 22 20 61 6e 64 22 |ted," = |"," and"|
|00000f50| 29 20 2a 2f 0d 0a 20 20 | 20 20 20 20 25 4a 6f 69 |) */.. | %Joi|
|00000f60| 6e 46 4b 50 4b 28 25 43 | 68 69 6c 64 2c 64 65 6c |nFKPK(%C|hild,del|
|00000f70| 65 74 65 64 2c 22 20 3d | 20 22 2c 22 20 61 6e 64 |eted," =| "," and|
|00000f80| 22 29 3a 0d 0a 20 20 20 | 20 20 20 20 20 25 46 6f |"):.. | %Fo|
|00000f90| 72 45 61 63 68 46 4b 41 | 74 74 28 22 2e 22 29 20 |rEachFKA|tt(".") |
|00000fa0| 7b 0d 0a 20 20 20 20 20 | 20 20 20 41 53 53 49 47 |{.. | ASSIG|
|00000fb0| 4e 20 25 43 68 69 6c 64 | 2e 25 41 74 74 46 69 65 |N %Child|.%AttFie|
|00000fc0| 6c 64 4e 61 6d 65 20 3d | 20 69 6e 73 65 72 74 65 |ldName =| inserte|
|00000fd0| 64 2e 25 50 61 72 65 6e | 74 41 74 74 28 25 41 74 |d.%Paren|tAtt(%At|
|00000fe0| 74 46 69 65 6c 64 4e 61 | 6d 65 29 7d 2e 0d 0a 20 |tFieldNa|me)}... |
|00000ff0| 20 20 20 20 20 45 4e 44 | 2e 0d 0a 20 20 45 4e 44 | END|... END|
|00001000| 2e 0d 0a 11 27 00 00 00 | 00 00 00 00 00 00 00 05 |....'...|........|
|00001010| 00 00 00 16 00 50 41 52 | 45 4e 54 20 55 50 44 41 |.....PAR|ENT UPDA|
|00001020| 54 45 20 53 45 54 20 4e | 55 4c 4c 92 01 20 20 2f |TE SET N|ULL.. /|
|00001030| 2a 20 25 50 61 72 65 6e | 74 20 25 56 65 72 62 50 |* %Paren|t %VerbP|
|00001040| 68 72 61 73 65 20 25 43 | 68 69 6c 64 20 4f 4e 20 |hrase %C|hild ON |
|00001050| 50 41 52 45 4e 54 20 55 | 50 44 41 54 45 20 53 45 |PARENT U|PDATE SE|
|00001060| 54 20 4e 55 4c 4c 20 2a | 2f 0d 0a 20 20 49 46 0d |T NULL *|/.. IF.|
|00001070| 0a 20 20 20 20 2f 2a 20 | 25 25 4a 6f 69 6e 50 4b |. /* |%%JoinPK|
|00001080| 50 4b 28 64 65 6c 65 74 | 65 64 2c 69 6e 73 65 72 |PK(delet|ed,inser|
|00001090| 74 65 64 2c 22 20 3c 3e | 20 22 2c 22 20 6f 72 20 |ted," <>| "," or |
|000010a0| 22 29 20 2a 2f 0d 0a 20 | 20 20 20 25 4a 6f 69 6e |") */.. | %Join|
|000010b0| 50 4b 50 4b 28 64 65 6c | 65 74 65 64 2c 69 6e 73 |PKPK(del|eted,ins|
|000010c0| 65 72 74 65 64 2c 22 20 | 3c 3e 20 22 2c 22 20 6f |erted," |<> "," o|
|000010d0| 72 20 22 29 0d 0a 20 20 | 54 48 45 4e 20 44 4f 3a |r ").. |THEN DO:|
|000010e0| 0d 0a 20 20 20 20 46 4f | 52 20 45 41 43 48 20 25 |.. FO|R EACH %|
|000010f0| 43 68 69 6c 64 20 57 48 | 45 52 45 0d 0a 20 20 20 |Child WH|ERE.. |
|00001100| 20 20 20 2f 2a 20 20 25 | 25 4a 6f 69 6e 46 4b 50 | /* %|%JoinFKP|
|00001110| 4b 28 25 43 68 69 6c 64 | 2c 64 65 6c 65 74 65 64 |K(%Child|,deleted|
|00001120| 2c 22 20 3d 20 22 2c 22 | 20 61 6e 64 22 29 20 2a |," = ","| and") *|
|00001130| 2f 0d 0a 20 20 20 20 20 | 20 25 4a 6f 69 6e 46 4b |/.. | %JoinFK|
|00001140| 50 4b 28 25 43 68 69 6c | 64 2c 64 65 6c 65 74 65 |PK(%Chil|d,delete|
|00001150| 64 2c 22 20 3d 20 22 2c | 22 20 61 6e 64 22 29 3a |d," = ",|" and"):|
|00001160| 0d 0a 20 20 20 20 20 20 | 20 20 25 46 6f 72 45 61 |.. | %ForEa|
|00001170| 63 68 46 4b 41 74 74 28 | 22 2e 22 29 20 7b 0d 0a |chFKAtt(|".") {..|
|00001180| 20 20 20 20 20 20 20 20 | 41 53 53 49 47 4e 20 25 | |ASSIGN %|
|00001190| 43 68 69 6c 64 2e 25 41 | 74 74 46 69 65 6c 64 4e |Child.%A|ttFieldN|
|000011a0| 61 6d 65 20 3d 20 3f 7d | 2e 0d 0a 20 20 20 20 20 |ame = ?}|... |
|000011b0| 20 45 4e 44 2e 0d 0a 20 | 20 45 4e 44 2e 0d 0a 12 | END... | END....|
|000011c0| 27 00 00 00 00 00 00 00 | 00 00 00 05 00 00 00 16 |'.......|........|
|000011d0| 00 50 41 52 45 4e 54 20 | 44 45 4c 45 54 45 20 52 |.PARENT |DELETE R|
|000011e0| 45 53 54 52 49 43 54 4f | 01 20 20 2f 2a 20 45 52 |ESTRICTO|. /* ER|
|000011f0| 77 69 6e 20 42 75 69 6c | 74 69 6e 20 25 44 61 74 |win Buil|tin %Dat|
|00001200| 65 74 69 6d 65 20 2a 2f | 0d 0a 20 20 2f 2a 20 25 |etime */|.. /* %|
|00001210| 50 61 72 65 6e 74 20 25 | 56 65 72 62 50 68 72 61 |Parent %|VerbPhra|
|00001220| 73 65 20 25 43 68 69 6c | 64 20 4f 4e 20 50 41 52 |se %Chil|d ON PAR|
|00001230| 45 4e 54 20 44 45 4c 45 | 54 45 20 52 45 53 54 52 |ENT DELE|TE RESTR|
|00001240| 49 43 54 20 2a 2f 0d 0a | 20 20 49 46 20 43 41 4e |ICT */..| IF CAN|
|00001250| 2d 46 49 4e 44 28 46 49 | 52 53 54 20 25 43 68 69 |-FIND(FI|RST %Chi|
|00001260| 6c 64 20 57 48 45 52 45 | 0d 0a 20 20 20 20 20 20 |ld WHERE|.. |
|00001270| 2f 2a 20 20 25 25 4a 6f | 69 6e 46 4b 50 4b 28 25 |/* %%Jo|inFKPK(%|
|00001280| 43 68 69 6c 64 2c 25 50 | 61 72 65 6e 74 2c 22 20 |Child,%P|arent," |
|00001290| 3d 20 22 2c 22 20 61 6e | 64 22 29 20 2a 2f 0d 0a |= "," an|d") */..|
|000012a0| 20 20 20 20 20 20 25 4a | 6f 69 6e 46 4b 50 4b 28 | %J|oinFKPK(|
|000012b0| 25 43 68 69 6c 64 2c 25 | 50 61 72 65 6e 74 2c 22 |%Child,%|Parent,"|
|000012c0| 20 3d 20 22 2c 22 20 61 | 6e 64 22 29 29 0d 0a 20 | = "," a|nd")).. |
|000012d0| 20 54 48 45 4e 20 44 4f | 3a 20 0d 0a 20 20 20 20 | THEN DO|: .. |
|000012e0| 4d 45 53 53 41 47 45 20 | 22 43 61 6e 6e 6f 74 20 |MESSAGE |"Cannot |
|000012f0| 44 45 4c 45 54 45 20 27 | 25 50 61 72 65 6e 74 27 |DELETE '|%Parent'|
|00001300| 20 62 65 63 61 75 73 65 | 20 27 25 43 68 69 6c 64 | because| '%Child|
|00001310| 27 20 65 78 69 73 74 73 | 2e 22 2e 0d 0a 20 20 20 |' exists|."... |
|00001320| 20 52 45 54 55 52 4e 20 | 45 52 52 4f 52 2e 0d 0a | RETURN |ERROR...|
|00001330| 20 20 45 4e 44 2e 0d 0a | 14 27 00 00 00 00 00 00 | END...|.'......|
|00001340| 00 00 00 00 05 00 00 00 | 15 00 50 41 52 45 4e 54 |........|..PARENT|
|00001350| 20 44 45 4c 45 54 45 20 | 43 41 53 43 41 44 45 a3 | DELETE |CASCADE.|
|00001360| 00 20 20 20 20 2f 2a 20 | 45 52 77 69 6e 20 42 75 |. /* |ERwin Bu|
|00001370| 69 6c 74 69 6e 20 25 44 | 61 74 65 74 69 6d 65 20 |iltin %D|atetime |
|00001380| 2a 2f 0d 0a 20 20 20 20 | 2f 2a 20 25 50 61 72 65 |*/.. |/* %Pare|
|00001390| 6e 74 20 25 56 65 72 62 | 50 68 72 61 73 65 20 25 |nt %Verb|Phrase %|
|000013a0| 43 68 69 6c 64 20 4f 4e | 20 50 41 52 45 4e 54 20 |Child ON| PARENT |
|000013b0| 44 45 4c 45 54 45 20 43 | 41 53 43 41 44 45 20 2a |DELETE C|ASCADE *|
|000013c0| 2f 0d 0a 20 20 20 20 46 | 4f 52 20 45 41 43 48 20 |/.. F|OR EACH |
|000013d0| 25 43 68 69 6c 64 20 4f | 46 20 25 50 61 72 65 6e |%Child O|F %Paren|
|000013e0| 74 3a 0d 0a 20 20 20 20 | 20 20 44 45 4c 45 54 45 |t:.. | DELETE|
|000013f0| 20 25 43 68 69 6c 64 2e | 0d 0a 20 20 20 20 45 4e | %Child.|.. EN|
|00001400| 44 2e 0d 0a 15 27 00 00 | 00 00 00 00 00 00 00 00 |D....'..|........|
|00001410| 05 00 00 00 16 00 50 41 | 52 45 4e 54 20 44 45 4c |......PA|RENT DEL|
|00001420| 45 54 45 20 53 45 54 20 | 4e 55 4c 4c d7 00 20 20 |ETE SET |NULL.. |
|00001430| 20 20 2f 2a 20 45 52 77 | 69 6e 20 42 75 69 6c 74 | /* ERw|in Built|
|00001440| 69 6e 20 25 44 61 74 65 | 74 69 6d 65 20 2a 2f 0d |in %Date|time */.|
|00001450| 0a 20 20 20 20 2f 2a 20 | 25 50 61 72 65 6e 74 20 |. /* |%Parent |
|00001460| 25 56 65 72 62 50 68 72 | 61 73 65 20 25 43 68 69 |%VerbPhr|ase %Chi|
|00001470| 6c 64 20 4f 4e 20 50 41 | 52 45 4e 54 20 44 45 4c |ld ON PA|RENT DEL|
|00001480| 45 54 45 20 53 45 54 20 | 4e 55 4c 4c 20 2a 2f 0d |ETE SET |NULL */.|
|00001490| 0a 20 20 20 20 46 4f 52 | 20 45 41 43 48 20 25 43 |. FOR| EACH %C|
|000014a0| 68 69 6c 64 20 4f 46 20 | 25 50 61 72 65 6e 74 3a |hild OF |%Parent:|
|000014b0| 0d 0a 20 20 20 20 20 20 | 20 20 25 46 6f 72 45 61 |.. | %ForEa|
|000014c0| 63 68 46 4b 41 74 74 28 | 22 2e 22 29 20 7b 0d 0a |chFKAtt(|".") {..|
|000014d0| 20 20 20 20 20 20 20 20 | 41 53 53 49 47 4e 20 25 | |ASSIGN %|
|000014e0| 43 68 69 6c 64 2e 25 41 | 74 74 46 69 65 6c 64 4e |Child.%A|ttFieldN|
|000014f0| 61 6d 65 20 3d 20 3f 7d | 2e 0d 0a 20 20 20 20 45 |ame = ?}|... E|
|00001500| 4e 44 2e 0d 0a 16 27 00 | 00 00 00 00 00 00 00 00 |ND....'.|........|
|00001510| 00 05 00 00 00 15 00 43 | 48 49 4c 44 20 49 4e 53 |.......C|HILD INS|
|00001520| 45 52 54 20 52 45 53 54 | 52 49 43 54 9a 00 20 20 |ERT REST|RICT.. |
|00001530| 20 20 2f 2a 20 45 52 77 | 69 6e 20 42 75 69 6c 74 | /* ERw|in Built|
|00001540| 69 6e 20 25 44 61 74 65 | 74 69 6d 65 20 2a 2f 0d |in %Date|time */.|
|00001550| 0a 20 20 20 20 2f 2a 20 | 25 50 61 72 65 6e 74 20 |. /* |%Parent |
|00001560| 25 56 65 72 62 50 68 72 | 61 73 65 20 25 43 68 69 |%VerbPhr|ase %Chi|
|00001570| 6c 64 20 4f 4e 20 43 48 | 49 4c 44 20 49 4e 53 45 |ld ON CH|ILD INSE|
|00001580| 52 54 20 52 45 53 54 52 | 49 43 54 20 2a 2f 0d 0a |RT RESTR|ICT */..|
|00001590| 20 20 20 20 2f 2a 20 41 | 70 70 6c 69 63 61 74 69 | /* A|pplicati|
|000015a0| 6f 6e 20 73 70 65 63 69 | 66 69 63 2e 20 20 4c 65 |on speci|fic. Le|
|000015b0| 66 74 20 6f 75 74 20 69 | 6e 74 65 6e 74 69 6f 6e |ft out i|ntention|
|000015c0| 61 6c 6c 79 2e 20 2a 2f | 18 27 00 00 00 00 00 00 |ally. */|.'......|
|000015d0| 00 00 00 00 05 00 00 00 | 14 00 43 48 49 4c 44 20 |........|..CHILD |
|000015e0| 49 4e 53 45 52 54 20 43 | 41 53 43 41 44 45 8d 00 |INSERT C|ASCADE..|
|000015f0| 2f 2a 20 45 52 77 69 6e | 20 42 75 69 6c 74 69 6e |/* ERwin| Builtin|
|00001600| 20 25 44 61 74 65 74 69 | 6d 65 20 2a 2f 0d 0a 2f | %Dateti|me */../|
|00001610| 2a 20 25 50 61 72 65 6e | 74 20 25 56 65 72 62 50 |* %Paren|t %VerbP|
|00001620| 68 72 61 73 65 20 25 43 | 68 69 6c 64 20 4f 4e 20 |hrase %C|hild ON |
|00001630| 43 48 49 4c 44 20 49 4e | 53 45 52 54 20 43 41 53 |CHILD IN|SERT CAS|
|00001640| 43 41 44 45 20 2a 2f 0d | 0a 2f 2a 20 41 70 70 6c |CADE */.|./* Appl|
|00001650| 69 63 61 74 69 6f 6e 20 | 73 70 65 63 69 66 69 63 |ication |specific|
|00001660| 2e 20 20 4c 65 66 74 20 | 6f 75 74 20 69 6e 74 65 |. Left |out inte|
|00001670| 6e 74 69 6f 6e 61 6c 6c | 79 2e 20 2a 2f 19 27 00 |ntionall|y. */.'.|
|00001680| 00 00 00 00 00 00 00 00 | 00 05 00 00 00 14 00 43 |........|.......C|
|00001690| 48 49 4c 44 20 49 4e 53 | 45 52 54 20 53 45 54 4e |HILD INS|ERT SETN|
|000016a0| 55 4c 4c 9a 00 20 20 20 | 20 2f 2a 20 45 52 77 69 |ULL.. | /* ERwi|
|000016b0| 6e 20 42 75 69 6c 74 69 | 6e 20 25 44 61 74 65 74 |n Builti|n %Datet|
|000016c0| 69 6d 65 20 2a 2f 0d 0a | 20 20 20 20 2f 2a 20 25 |ime */..| /* %|
|000016d0| 50 61 72 65 6e 74 20 25 | 56 65 72 62 50 68 72 61 |Parent %|VerbPhra|
|000016e0| 73 65 20 25 43 68 69 6c | 64 20 4f 4e 20 43 48 49 |se %Chil|d ON CHI|
|000016f0| 4c 44 20 49 4e 53 45 52 | 54 20 53 45 54 20 4e 55 |LD INSER|T SET NU|
|00001700| 4c 4c 20 2a 2f 0d 0a 20 | 20 20 20 2f 2a 20 41 70 |LL */.. | /* Ap|
|00001710| 70 6c 69 63 61 74 69 6f | 6e 20 73 70 65 63 69 66 |plicatio|n specif|
|00001720| 69 63 2e 20 20 4c 65 66 | 74 20 6f 75 74 20 69 6e |ic. Lef|t out in|
|00001730| 74 65 6e 74 69 6f 6e 61 | 6c 6c 79 2e 20 2a 2f 1a |tentiona|lly. */.|
|00001740| 27 00 00 00 00 00 00 00 | 00 00 00 05 00 00 00 15 |'.......|........|
|00001750| 00 43 48 49 4c 44 20 55 | 50 44 41 54 45 20 52 45 |.CHILD U|PDATE RE|
|00001760| 53 54 52 49 43 54 6c 01 | 20 20 2f 2a 20 45 52 77 |STRICTl.| /* ERw|
|00001770| 69 6e 20 42 75 69 6c 74 | 69 6e 20 25 44 61 74 65 |in Built|in %Date|
|00001780| 74 69 6d 65 20 2a 2f 0d | 0a 20 20 2f 2a 20 25 50 |time */.|. /* %P|
|00001790| 61 72 65 6e 74 20 25 56 | 65 72 62 50 68 72 61 73 |arent %V|erbPhras|
|000017a0| 65 20 25 43 68 69 6c 64 | 20 4f 4e 20 43 48 49 4c |e %Child| ON CHIL|
|000017b0| 44 20 55 50 44 41 54 45 | 20 52 45 53 54 52 49 43 |D UPDATE| RESTRIC|
|000017c0| 54 20 2a 2f 0d 0a 20 20 | 20 20 49 46 20 4e 4f 54 |T */.. | IF NOT|
|000017d0| 28 43 41 4e 2d 46 49 4e | 44 28 46 49 52 53 54 20 |(CAN-FIN|D(FIRST |
|000017e0| 25 50 61 72 65 6e 74 20 | 57 48 45 52 45 0d 0a 20 |%Parent |WHERE.. |
|000017f0| 20 20 20 20 20 20 20 2f | 2a 20 25 25 4a 6f 69 6e | /|* %%Join|
|00001800| 46 4b 50 4b 28 69 6e 73 | 65 72 74 65 64 2c 25 50 |FKPK(ins|erted,%P|
|00001810| 61 72 65 6e 74 2c 22 20 | 3d 20 22 2c 22 20 61 6e |arent," |= "," an|
|00001820| 64 22 29 20 2a 2f 0d 0a | 20 20 20 20 20 20 20 20 |d") */..| |
|00001830| 25 4a 6f 69 6e 46 4b 50 | 4b 28 69 6e 73 65 72 74 |%JoinFKP|K(insert|
|00001840| 65 64 2c 25 50 61 72 65 | 6e 74 2c 22 20 3d 20 22 |ed,%Pare|nt," = "|
|00001850| 2c 22 20 61 6e 64 22 29 | 29 29 0d 0a 20 20 20 20 |," and")|)).. |
|00001860| 54 48 45 4e 20 44 4f 3a | 0d 0a 20 20 20 20 20 20 |THEN DO:|.. |
|00001870| 4d 45 53 53 41 47 45 20 | 22 43 61 6e 6e 6f 74 20 |MESSAGE |"Cannot |
|00001880| 55 50 44 41 54 45 20 27 | 25 43 68 69 6c 64 27 20 |UPDATE '|%Child' |
|00001890| 62 65 63 61 75 73 65 20 | 27 25 50 61 72 65 6e 74 |because |'%Parent|
|000018a0| 27 20 64 6f 65 73 20 6e | 6f 74 20 65 78 69 73 74 |' does n|ot exist|
|000018b0| 2e 22 2e 0d 0a 20 20 20 | 20 20 20 52 45 54 55 52 |."... | RETUR|
|000018c0| 4e 20 45 52 52 4f 52 2e | 0d 0a 20 20 20 20 45 4e |N ERROR.|.. EN|
|000018d0| 44 2e 0d 0a 1c 27 00 00 | 00 00 00 00 00 00 00 00 |D....'..|........|
|000018e0| 05 00 00 00 14 00 43 48 | 49 4c 44 20 55 50 44 41 |......CH|ILD UPDA|
|000018f0| 54 45 20 43 41 53 43 41 | 44 45 8d 00 2f 2a 20 45 |TE CASCA|DE../* E|
|00001900| 52 77 69 6e 20 42 75 69 | 6c 74 69 6e 20 25 44 61 |Rwin Bui|ltin %Da|
|00001910| 74 65 74 69 6d 65 20 2a | 2f 0d 0a 2f 2a 20 25 50 |tetime *|/../* %P|
|00001920| 61 72 65 6e 74 20 25 56 | 65 72 62 50 68 72 61 73 |arent %V|erbPhras|
|00001930| 65 20 25 43 68 69 6c 64 | 20 4f 4e 20 43 48 49 4c |e %Child| ON CHIL|
|00001940| 44 20 55 50 44 41 54 45 | 20 43 41 53 43 41 44 45 |D UPDATE| CASCADE|
|00001950| 20 2a 2f 0d 0a 2f 2a 20 | 41 70 70 6c 69 63 61 74 | */../* |Applicat|
|00001960| 69 6f 6e 20 73 70 65 63 | 69 66 69 63 2e 20 20 4c |ion spec|ific. L|
|00001970| 65 66 74 20 6f 75 74 20 | 69 6e 74 65 6e 74 69 6f |eft out |intentio|
|00001980| 6e 61 6c 6c 79 2e 20 2a | 2f 1d 27 00 00 00 00 00 |nally. *|/.'.....|
|00001990| 00 00 00 00 00 05 00 00 | 00 14 00 43 48 49 4c 44 |........|...CHILD|
|000019a0| 20 55 50 44 41 54 45 20 | 53 45 54 4e 55 4c 4c 5b | UPDATE |SETNULL[|
|000019b0| 01 20 20 20 20 2f 2a 20 | 45 52 77 69 6e 20 42 75 |. /* |ERwin Bu|
|000019c0| 69 6c 74 69 6e 20 25 44 | 61 74 65 74 69 6d 65 20 |iltin %D|atetime |
|000019d0| 2a 2f 0d 0a 20 20 20 20 | 2f 2a 20 25 50 61 72 65 |*/.. |/* %Pare|
|000019e0| 6e 74 20 25 56 65 72 62 | 50 68 72 61 73 65 20 25 |nt %Verb|Phrase %|
|000019f0| 43 68 69 6c 64 20 4f 4e | 20 43 48 49 4c 44 20 55 |Child ON| CHILD U|
|00001a00| 50 44 41 54 45 20 53 45 | 54 20 4e 55 4c 4c 20 2a |PDATE SE|T NULL *|
|00001a10| 2f 0d 0a 20 20 20 20 49 | 46 20 4e 4f 54 28 43 41 |/.. I|F NOT(CA|
|00001a20| 4e 2d 46 49 4e 44 28 46 | 49 52 53 54 20 25 50 61 |N-FIND(F|IRST %Pa|
|00001a30| 72 65 6e 74 20 57 48 45 | 52 45 0d 0a 20 20 20 20 |rent WHE|RE.. |
|00001a40| 20 20 20 20 2f 2a 20 25 | 25 4a 6f 69 6e 46 4b 50 | /* %|%JoinFKP|
|00001a50| 4b 28 69 6e 73 65 72 74 | 65 64 2c 25 50 61 72 65 |K(insert|ed,%Pare|
|00001a60| 6e 74 2c 22 20 3d 20 22 | 2c 22 20 61 6e 64 22 29 |nt," = "|," and")|
|00001a70| 20 2a 2f 0d 0a 20 20 20 | 20 20 20 20 20 25 4a 6f | */.. | %Jo|
|00001a80| 69 6e 46 4b 50 4b 28 69 | 6e 73 65 72 74 65 64 2c |inFKPK(i|nserted,|
|00001a90| 25 50 61 72 65 6e 74 2c | 22 20 3d 20 22 2c 22 20 |%Parent,|" = "," |
|00001aa0| 61 6e 64 22 29 29 29 0d | 0a 20 20 20 20 54 48 45 |and"))).|. THE|
|00001ab0| 4e 20 44 4f 3a 0d 0a 20 | 20 20 20 20 20 20 20 25 |N DO:.. | %|
|00001ac0| 46 6f 72 45 61 63 68 46 | 4b 41 74 74 28 22 2e 22 |ForEachF|KAtt("."|
|00001ad0| 29 20 7b 0d 0a 20 20 20 | 20 20 20 20 20 41 53 53 |) {.. | ASS|
|00001ae0| 49 47 4e 20 69 6e 73 65 | 72 74 65 64 2e 25 41 74 |IGN inse|rted.%At|
|00001af0| 74 46 69 65 6c 64 4e 61 | 6d 65 20 3d 20 3f 7d 2e |tFieldNa|me = ?}.|
|00001b00| 0d 0a 20 20 20 20 45 4e | 44 2e 0d 0a 1e 27 00 00 |.. EN|D....'..|
|00001b10| 00 00 00 00 00 00 00 00 | 05 00 00 00 15 00 43 48 |........|......CH|
|00001b20| 49 4c 44 20 44 45 4c 45 | 54 45 20 52 45 53 54 52 |ILD DELE|TE RESTR|
|00001b30| 49 43 54 60 01 20 20 20 | 20 2f 2a 20 45 52 77 69 |ICT`. | /* ERwi|
|00001b40| 6e 20 42 75 69 6c 74 69 | 6e 20 25 44 61 74 65 74 |n Builti|n %Datet|
|00001b50| 69 6d 65 20 2a 2f 0d 0a | 20 20 20 20 2f 2a 20 25 |ime */..| /* %|
|00001b60| 50 61 72 65 6e 74 20 25 | 56 65 72 62 50 68 72 61 |Parent %|VerbPhra|
|00001b70| 73 65 20 25 43 68 69 6c | 64 20 4f 4e 20 43 48 49 |se %Chil|d ON CHI|
|00001b80| 4c 44 20 44 45 4c 45 54 | 45 20 52 45 53 54 52 49 |LD DELET|E RESTRI|
|00001b90| 43 54 20 2a 2f 0d 0a 20 | 20 20 20 49 46 20 43 41 |CT */.. | IF CA|
|00001ba0| 4e 2d 46 49 4e 44 28 46 | 49 52 53 54 20 25 50 61 |N-FIND(F|IRST %Pa|
|00001bb0| 72 65 6e 74 20 57 48 45 | 52 45 0d 0a 20 20 20 20 |rent WHE|RE.. |
|00001bc0| 20 20 20 20 2f 2a 20 25 | 25 4a 6f 69 6e 46 4b 50 | /* %|%JoinFKP|
|00001bd0| 4b 28 25 43 68 69 6c 64 | 2c 25 50 61 72 65 6e 74 |K(%Child|,%Parent|
|00001be0| 2c 22 20 3d 20 22 2c 22 | 20 61 6e 64 22 29 20 2a |," = ","| and") *|
|00001bf0| 2f 0d 0a 20 20 20 20 20 | 20 20 20 25 4a 6f 69 6e |/.. | %Join|
|00001c00| 46 4b 50 4b 28 25 43 68 | 69 6c 64 2c 25 50 61 72 |FKPK(%Ch|ild,%Par|
|00001c10| 65 6e 74 2c 22 20 3d 20 | 22 2c 22 20 61 6e 64 22 |ent," = |"," and"|
|00001c20| 29 29 29 0d 0a 20 20 20 | 20 54 48 45 4e 20 44 4f |))).. | THEN DO|
|00001c30| 3a 0d 0a 20 20 20 20 20 | 20 4d 45 53 53 41 47 45 |:.. | MESSAGE|
|00001c40| 20 22 43 61 6e 6e 6f 74 | 20 44 45 4c 45 54 45 20 | "Cannot| DELETE |
|00001c50| 27 25 43 68 69 6c 64 27 | 20 62 65 63 61 75 73 65 |'%Child'| because|
|00001c60| 20 27 25 50 61 72 65 6e | 74 27 20 65 78 69 73 74 | '%Paren|t' exist|
|00001c70| 73 2e 22 2e 0d 0a 20 20 | 20 20 20 20 52 45 54 55 |s."... | RETU|
|00001c80| 52 4e 20 45 52 52 4f 52 | 2e 0d 0a 20 20 20 20 45 |RN ERROR|... E|
|00001c90| 4e 44 2e 0d 0a 20 27 00 | 00 00 00 00 00 00 00 00 |ND... '.|........|
|00001ca0| 00 05 00 00 00 14 00 43 | 48 49 4c 44 20 44 45 4c |.......C|HILD DEL|
|00001cb0| 45 54 45 20 43 41 53 43 | 41 44 45 a3 00 20 20 20 |ETE CASC|ADE.. |
|00001cc0| 20 2f 2a 20 45 52 77 69 | 6e 20 42 75 69 6c 74 69 | /* ERwi|n Builti|
|00001cd0| 6e 20 25 44 61 74 65 74 | 69 6d 65 20 2a 2f 0d 0a |n %Datet|ime */..|
|00001ce0| 20 20 20 20 2f 2a 20 25 | 50 61 72 65 6e 74 20 25 | /* %|Parent %|
|00001cf0| 56 65 72 62 50 68 72 61 | 73 65 20 25 43 68 69 6c |VerbPhra|se %Chil|
|00001d00| 64 20 4f 4e 20 43 48 49 | 4c 44 20 44 45 4c 45 54 |d ON CHI|LD DELET|
|00001d10| 45 20 43 41 53 43 41 44 | 45 20 2a 2f 0d 0a 20 20 |E CASCAD|E */.. |
|00001d20| 20 20 46 4f 52 20 45 41 | 43 48 20 25 50 61 72 65 | FOR EA|CH %Pare|
|00001d30| 6e 74 20 4f 46 20 25 43 | 68 69 6c 64 3a 0d 0a 20 |nt OF %C|hild:.. |
|00001d40| 20 20 20 20 20 44 45 4c | 45 54 45 20 25 50 61 72 | DEL|ETE %Par|
|00001d50| 65 6e 74 2e 0d 0a 20 20 | 20 20 45 4e 44 2e 0d 0a |ent... | END...|
|00001d60| 21 27 00 00 00 00 00 00 | 00 00 00 00 05 00 00 00 |!'......|........|
|00001d70| 16 00 50 41 52 45 4e 54 | 20 49 4e 53 45 52 54 20 |..PARENT| INSERT |
|00001d80| 52 45 53 54 52 49 43 54 | 8f 00 2f 2a 20 45 52 77 |RESTRICT|../* ERw|
|00001d90| 69 6e 20 42 75 69 6c 74 | 69 6e 20 25 44 61 74 65 |in Built|in %Date|
|00001da0| 74 69 6d 65 20 2a 2f 0d | 0a 2f 2a 20 25 50 61 72 |time */.|./* %Par|
|00001db0| 65 6e 74 20 25 56 65 72 | 62 50 68 72 61 73 65 20 |ent %Ver|bPhrase |
|00001dc0| 25 43 68 69 6c 64 20 4f | 4e 20 50 41 52 45 4e 54 |%Child O|N PARENT|
|00001dd0| 20 49 4e 53 45 52 54 20 | 52 45 53 54 52 49 43 54 | INSERT |RESTRICT|
|00001de0| 20 2a 2f 0d 0a 2f 2a 20 | 41 70 70 6c 69 63 61 74 | */../* |Applicat|
|00001df0| 69 6f 6e 20 73 70 65 63 | 69 66 69 63 2e 20 20 4c |ion spec|ific. L|
|00001e00| 65 66 74 20 6f 75 74 20 | 69 6e 74 65 6e 74 69 6f |eft out |intentio|
|00001e10| 6e 61 6c 6c 79 2e 20 2a | 2f 24 27 00 00 00 00 00 |nally. *|/$'.....|
|00001e20| 00 00 00 00 00 05 00 00 | 00 0d 00 55 50 44 41 54 |........|...UPDAT|
|00001e30| 45 20 48 45 41 44 45 52 | 8a 00 54 52 49 47 47 45 |E HEADER|..TRIGGE|
|00001e40| 52 20 50 52 4f 43 45 44 | 55 52 45 20 46 4f 52 20 |R PROCED|URE FOR |
|00001e50| 57 52 49 54 45 20 4f 46 | 20 25 54 61 62 6c 65 4e |WRITE OF| %TableN|
|00001e60| 61 6d 65 0d 0a 2f 2a 20 | 45 52 77 69 6e 20 42 75 |ame../* |ERwin Bu|
|00001e70| 69 6c 74 69 6e 20 25 44 | 61 74 65 74 69 6d 65 20 |iltin %D|atetime |
|00001e80| 2a 2f 0d 0a 2f 2a 20 25 | 41 63 74 69 6f 6e 20 74 |*/../* %|Action t|
|00001e90| 72 69 67 67 65 72 20 6f | 6e 20 25 54 61 62 6c 65 |rigger o|n %Table|
|00001ea0| 4e 61 6d 65 20 2a 2f 0d | 0a 4e 45 57 20 69 6e 73 |Name */.|.NEW ins|
|00001eb0| 65 72 74 65 64 20 4f 4c | 44 20 64 65 6c 65 74 65 |erted OL|D delete|
|00001ec0| 64 2e 0d 0a 28 27 00 00 | 00 00 00 00 00 00 00 00 |d...('..|........|
|00001ed0| 05 00 00 00 0d 00 55 50 | 44 41 54 45 20 46 4f 4f |......UP|DATE FOO|
|00001ee0| 54 45 52 21 00 2f 2a 20 | 45 52 77 69 6e 20 42 75 |TER!./* |ERwin Bu|
|00001ef0| 69 6c 74 69 6e 20 25 44 | 61 74 65 74 69 6d 65 20 |iltin %D|atetime |
|00001f00| 2a 2f 0d 0a 0d 0a 29 27 | 00 00 00 00 00 00 00 00 |*/....)'|........|
|00001f10| 00 00 05 00 00 00 0d 00 | 44 45 4c 45 54 45 20 48 |........|DELETE H|
|00001f20| 45 41 44 45 52 71 00 54 | 52 49 47 47 45 52 20 50 |EADERq.T|RIGGER P|
|00001f30| 52 4f 43 45 44 55 52 45 | 20 46 4f 52 20 44 45 4c |ROCEDURE| FOR DEL|
|00001f40| 45 54 45 20 4f 46 20 25 | 54 61 62 6c 65 4e 61 6d |ETE OF %|TableNam|
|00001f50| 65 2e 0d 0a 2f 2a 20 45 | 52 77 69 6e 20 42 75 69 |e.../* E|Rwin Bui|
|00001f60| 6c 74 69 6e 20 25 44 61 | 74 65 74 69 6d 65 20 2a |ltin %Da|tetime *|
|00001f70| 2f 0d 0a 2f 2a 20 25 41 | 63 74 69 6f 6e 20 74 72 |/../* %A|ction tr|
|00001f80| 69 67 67 65 72 20 6f 6e | 20 25 54 61 62 6c 65 4e |igger on| %TableN|
|00001f90| 61 6d 65 20 2a 2f 0d 0a | 2a 27 00 00 00 00 00 00 |ame */..|*'......|
|00001fa0| 00 00 00 00 05 00 00 00 | 0d 00 44 45 4c 45 54 45 |........|..DELETE|
|00001fb0| 20 46 4f 4f 54 45 52 21 | 00 2f 2a 20 45 52 77 69 | FOOTER!|./* ERwi|
|00001fc0| 6e 20 42 75 69 6c 74 69 | 6e 20 25 44 61 74 65 74 |n Builti|n %Datet|
|00001fd0| 69 6d 65 20 2a 2f 0d 0a | 0d 0a 2b 27 00 00 00 00 |ime */..|..+'....|
|00001fe0| 00 00 00 00 00 00 05 00 | 00 00 0d 00 49 4e 53 45 |........|....INSE|
|00001ff0| 52 54 20 48 45 41 44 45 | 52 44 00 2f 2a 20 45 52 |RT HEADE|RD./* ER|
|00002000| 77 69 6e 20 42 75 69 6c | 74 69 6e 20 25 44 61 74 |win Buil|tin %Dat|
|00002010| 65 74 69 6d 65 20 2a 2f | 0d 0a 2f 2a 20 25 41 63 |etime */|../* %Ac|
|00002020| 74 69 6f 6e 20 74 72 69 | 67 67 65 72 20 6f 6e 20 |tion tri|gger on |
|00002030| 25 54 61 62 6c 65 4e 61 | 6d 65 20 2a 2f 0d 0a 2c |%TableNa|me */..,|
|00002040| 27 00 00 00 00 00 00 00 | 00 00 00 05 00 00 00 0d |'.......|........|
|00002050| 00 49 4e 53 45 52 54 20 | 46 4f 4f 54 45 52 00 00 |.INSERT |FOOTER..|
|00002060| 00 00 00 00 00 00 00 00 | 00 00 00 00 05 00 00 00 |........|........|
|00002070| 15 00 43 55 53 54 4f 4d | 20 54 52 49 47 47 45 52 |..CUSTOM| TRIGGER|
|00002080| 20 48 45 41 44 45 52 00 | 00 00 00 00 00 00 00 00 | HEADER.|........|
|00002090| 00 00 00 00 00 05 00 00 | 00 15 00 43 55 53 54 4f |........|...CUSTO|
|000020a0| 4d 20 54 52 49 47 47 45 | 52 20 46 4f 4f 54 45 52 |M TRIGGE|R FOOTER|
|000020b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 05 00 |........|........|
|000020c0| 00 00 15 00 43 55 53 54 | 4f 4d 20 54 52 49 47 47 |....CUST|OM TRIGG|
|000020d0| 45 52 20 46 4f 4f 54 45 | 52 00 00 00 00 00 00 00 |ER FOOTE|R.......|
|000020e0| 00 00 00 00 00 00 00 05 | 00 00 00 15 00 43 55 53 |........|.....CUS|
|000020f0| 54 4f 4d 20 54 52 49 47 | 47 45 52 20 46 4f 4f 54 |TOM TRIG|GER FOOT|
|00002100| 45 52 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |ER......|........|
|00002110| 05 00 00 00 15 00 43 55 | 53 54 4f 4d 20 54 52 49 |......CU|STOM TRI|
|00002120| 47 47 45 52 20 46 4f 4f | 54 45 52 00 00 00 00 00 |GGER FOO|TER.....|
|00002130| 00 00 00 00 00 00 00 00 | 00 05 00 00 00 15 00 43 |........|.......C|
|00002140| 55 53 54 4f 4d 20 54 52 | 49 47 47 45 52 20 48 45 |USTOM TR|IGGER HE|
|00002150| 41 44 45 52 00 00 00 00 | 00 00 00 00 00 00 00 00 |ADER....|........|
|00002160| 00 00 05 00 00 00 15 00 | 43 55 53 54 4f 4d 20 54 |........|CUSTOM T|
|00002170| 52 49 47 47 45 52 20 46 | 4f 4f 54 45 52 00 00 00 |RIGGER F|OOTER...|
|00002180| 00 00 00 00 00 00 00 00 | 00 00 00 05 00 00 00 15 |........|........|
|00002190| 00 43 55 53 54 4f 4d 20 | 54 52 49 47 47 45 52 20 |.CUSTOM |TRIGGER |
|000021a0| 48 45 41 44 45 52 00 00 | 00 00 00 00 00 00 00 00 |HEADER..|........|
|000021b0| 00 00 00 00 05 00 00 00 | 15 00 43 55 53 54 4f 4d |........|..CUSTOM|
|000021c0| 20 54 52 49 47 47 45 52 | 20 46 4f 4f 54 45 52 00 | TRIGGER| FOOTER.|
|000021d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 05 00 00 |........|........|
|000021e0| 00 15 00 43 55 53 54 4f | 4d 20 54 52 49 47 47 45 |...CUSTO|M TRIGGE|
|000021f0| 52 20 48 45 41 44 45 52 | 00 00 00 00 00 00 00 00 |R HEADER|........|
|00002200| 00 00 00 00 00 00 05 00 | 00 00 15 00 43 55 53 54 |........|....CUST|
|00002210| 4f 4d 20 54 52 49 47 47 | 45 52 20 46 4f 4f 54 45 |OM TRIGG|ER FOOTE|
|00002220| 52 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 05 |R.......|........|
|00002230| 00 00 00 15 00 43 55 53 | 54 4f 4d 20 54 52 49 47 |.....CUS|TOM TRIG|
|00002240| 47 45 52 20 48 45 41 44 | 45 52 00 00 00 00 00 00 |GER HEAD|ER......|
|00002250| 00 00 00 00 00 00 00 00 | 05 00 00 00 15 00 43 55 |........|......CU|
|00002260| 53 54 4f 4d 20 54 52 49 | 47 47 45 52 20 46 4f 4f |STOM TRI|GGER FOO|
|00002270| 54 45 52 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |TER.....|........|
|00002280| 00 05 00 00 00 15 00 43 | 55 53 54 4f 4d 20 54 52 |.......C|USTOM TR|
|00002290| 49 47 47 45 52 20 48 45 | 41 44 45 52 00 00 00 00 |IGGER HE|ADER....|
|000022a0| 00 00 00 00 00 00 00 00 | 00 00 05 00 00 00 15 00 |........|........|
|000022b0| 43 55 53 54 4f 4d 20 54 | 52 49 47 47 45 52 20 46 |CUSTOM T|RIGGER F|
|000022c0| 4f 4f 54 45 52 00 00 00 | 00 00 00 00 00 00 00 00 |OOTER...|........|
|000022d0| 00 00 00 05 00 00 00 15 | 00 43 55 53 54 4f 4d 20 |........|.CUSTOM |
|000022e0| 54 52 49 47 47 45 52 20 | 48 45 41 44 45 52 00 00 |TRIGGER |HEADER..|
|000022f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 05 00 00 00 |........|........|
|00002300| 15 00 43 55 53 54 4f 4d | 20 54 52 49 47 47 45 52 |..CUSTOM| TRIGGER|
|00002310| 20 46 4f 4f 54 45 52 00 | 00 00 00 00 00 00 00 00 | FOOTER.|........|
|00002320| 00 00 00 00 00 05 00 00 | 00 15 00 43 55 53 54 4f |........|...CUSTO|
|00002330| 4d 20 54 52 49 47 47 45 | 52 20 48 45 41 44 45 52 |M TRIGGE|R HEADER|
|00002340| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 05 00 |........|........|
|00002350| 00 00 15 00 43 55 53 54 | 4f 4d 20 54 52 49 47 47 |....CUST|OM TRIGG|
|00002360| 45 52 20 46 4f 4f 54 45 | 52 00 00 00 00 00 00 00 |ER FOOTE|R.......|
|00002370| 00 00 00 00 00 00 00 05 | 00 00 00 15 00 43 55 53 |........|.....CUS|
|00002380| 54 4f 4d 20 54 52 49 47 | 47 45 52 20 48 45 41 44 |TOM TRIG|GER HEAD|
|00002390| 45 52 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |ER......|........|
|000023a0| 05 00 00 00 15 00 43 55 | 53 54 4f 4d 20 54 52 49 |......CU|STOM TRI|
|000023b0| 47 47 45 52 20 46 4f 4f | 54 45 52 00 00 00 00 00 |GGER FOO|TER.....|
|000023c0| 00 00 00 00 00 00 00 00 | 00 05 00 00 00 0d 00 49 |........|.......I|
|000023d0| 4e 53 45 52 54 20 46 4f | 4f 54 45 52 00 00 00 00 |NSERT FO|OTER....|
|000023e0| 00 00 00 00 00 00 00 00 | 00 00 05 00 00 00 15 00 |........|........|
|000023f0| 43 55 53 54 4f 4d 20 54 | 52 49 47 47 45 52 20 48 |CUSTOM T|RIGGER H|
|00002400| 45 41 44 45 52 00 00 00 | 00 00 00 00 00 00 00 00 |EADER...|........|
|00002410| 00 00 00 05 00 00 00 15 | 00 43 55 53 54 4f 4d 20 |........|.CUSTOM |
|00002420| 54 52 49 47 47 45 52 20 | 46 4f 4f 54 45 52 00 00 |TRIGGER |FOOTER..|
|00002430| 00 00 00 00 00 00 00 00 | 00 00 00 00 05 00 00 00 |........|........|
|00002440| 0d 00 49 4e 53 45 52 54 | 20 46 4f 4f 54 45 52 00 |..INSERT| FOOTER.|
|00002450| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 05 00 00 |........|........|
|00002460| 00 15 00 43 55 53 54 4f | 4d 20 54 52 49 47 47 45 |...CUSTO|M TRIGGE|
|00002470| 52 20 48 45 41 44 45 52 | 00 00 00 00 00 00 00 00 |R HEADER|........|
|00002480| 00 00 00 00 00 00 05 00 | 00 00 15 00 43 55 53 54 |........|....CUST|
|00002490| 4f 4d 20 54 52 49 47 47 | 45 52 20 46 4f 4f 54 45 |OM TRIGG|ER FOOTE|
|000024a0| 52 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 05 |R.......|........|
|000024b0| 00 00 00 0d 00 49 4e 53 | 45 52 54 20 46 4f 4f 54 |.....INS|ERT FOOT|
|000024c0| 45 52 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |ER......|........|
|000024d0| 05 00 00 00 15 00 43 55 | 53 54 4f 4d 20 54 52 49 |......CU|STOM TRI|
|000024e0| 47 47 45 52 20 48 45 41 | 44 45 52 00 00 00 00 00 |GGER HEA|DER.....|
|000024f0| 00 00 00 00 00 00 00 00 | 00 05 00 00 00 15 00 43 |........|.......C|
|00002500| 55 53 54 4f 4d 20 54 52 | 49 47 47 45 52 20 46 4f |USTOM TR|IGGER FO|
|00002510| 4f 54 45 52 00 00 00 00 | 00 00 00 00 00 00 00 00 |OTER....|........|
|00002520| 00 00 05 00 00 00 0d 00 | 49 4e 53 45 52 54 20 46 |........|INSERT F|
|00002530| 4f 4f 54 45 52 00 00 00 | 00 00 00 00 00 00 00 00 |OOTER...|........|
|00002540| 00 00 00 05 00 00 00 15 | 00 43 55 53 54 4f 4d 20 |........|.CUSTOM |
|00002550| 54 52 49 47 47 45 52 20 | 48 45 41 44 45 52 00 00 |TRIGGER |HEADER..|
|00002560| 00 00 00 00 00 00 00 00 | 00 00 00 00 05 00 00 00 |........|........|
|00002570| 15 00 43 55 53 54 4f 4d | 20 54 52 49 47 47 45 52 |..CUSTOM| TRIGGER|
|00002580| 20 46 4f 4f 54 45 52 00 | 00 00 00 00 00 00 00 00 | FOOTER.|........|
|00002590| 00 00 00 00 00 05 00 00 | 00 0d 00 49 4e 53 45 52 |........|...INSER|
|000025a0| 54 20 46 4f 4f 54 45 52 | 00 00 00 00 00 00 00 00 |T FOOTER|........|
|000025b0| 00 00 00 00 00 00 05 00 | 00 00 15 00 43 55 53 54 |........|....CUST|
|000025c0| 4f 4d 20 54 52 49 47 47 | 45 52 20 48 45 41 44 45 |OM TRIGG|ER HEADE|
|000025d0| 52 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 05 |R.......|........|
|000025e0| 00 00 00 15 00 43 55 53 | 54 4f 4d 20 54 52 49 47 |.....CUS|TOM TRIG|
|000025f0| 47 45 52 20 46 4f 4f 54 | 45 52 00 00 00 00 00 00 |GER FOOT|ER......|
|00002600| 00 00 00 00 00 00 00 00 | 05 00 00 00 0d 00 49 4e |........|......IN|
|00002610| 53 45 52 54 20 46 4f 4f | 54 45 52 00 00 00 00 00 |SERT FOO|TER.....|
|00002620| 00 00 00 00 00 00 00 00 | 00 05 00 00 00 15 00 43 |........|.......C|
|00002630| 55 53 54 4f 4d 20 54 52 | 49 47 47 45 52 20 48 45 |USTOM TR|IGGER HE|
|00002640| 41 44 45 52 00 00 00 00 | 00 00 00 00 00 00 00 00 |ADER....|........|
|00002650| 00 00 05 00 00 00 15 00 | 43 55 53 54 4f 4d 20 54 |........|CUSTOM T|
|00002660| 52 49 47 47 45 52 20 46 | 4f 4f 54 45 52 00 00 00 |RIGGER F|OOTER...|
|00002670| 00 00 00 00 00 00 00 00 | 00 00 00 05 00 00 00 0d |........|........|
|00002680| 00 49 4e 53 45 52 54 20 | 46 4f 4f 54 45 52 00 00 |.INSERT |FOOTER..|
|00002690| 00 00 00 00 00 00 00 00 | 00 00 00 00 05 00 00 00 |........|........|
|000026a0| 15 00 43 55 53 54 4f 4d | 20 54 52 49 47 47 45 52 |..CUSTOM| TRIGGER|
|000026b0| 20 48 45 41 44 45 52 00 | 00 00 00 00 00 00 00 00 | HEADER.|........|
|000026c0| 00 00 00 00 00 05 00 00 | 00 15 00 43 55 53 54 4f |........|...CUSTO|
|000026d0| 4d 20 54 52 49 47 47 45 | 52 20 46 4f 4f 54 45 52 |M TRIGGE|R FOOTER|
|000026e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 05 00 |........|........|
|000026f0| 00 00 0d 00 49 4e 53 45 | 52 54 20 46 4f 4f 54 45 |....INSE|RT FOOTE|
|00002700| 52 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 05 |R.......|........|
|00002710| 00 00 00 15 00 43 55 53 | 54 4f 4d 20 54 52 49 47 |.....CUS|TOM TRIG|
|00002720| 47 45 52 20 48 45 41 44 | 45 52 00 00 00 00 00 00 |GER HEAD|ER......|
|00002730| 00 00 00 00 00 00 00 00 | 05 00 00 00 15 00 43 55 |........|......CU|
|00002740| 53 54 4f 4d 20 54 52 49 | 47 47 45 52 20 46 4f 4f |STOM TRI|GGER FOO|
|00002750| 54 45 52 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |TER.....|........|
|00002760| 00 05 00 00 00 0d 00 49 | 4e 53 45 52 54 20 46 4f |.......I|NSERT FO|
|00002770| 4f 54 45 52 00 00 00 00 | 00 00 00 00 00 00 00 00 |OTER....|........|
|00002780| 00 00 05 00 00 00 15 00 | 43 55 53 54 4f 4d 20 54 |........|CUSTOM T|
|00002790| 52 49 47 47 45 52 20 48 | 45 41 44 45 52 00 00 00 |RIGGER H|EADER...|
|000027a0| 00 00 00 00 00 00 00 00 | 00 00 00 05 00 00 00 15 |........|........|
|000027b0| 00 43 55 53 54 4f 4d 20 | 54 52 49 47 47 45 52 20 |.CUSTOM |TRIGGER |
|000027c0| 46 4f 4f 54 45 52 00 00 | 00 00 00 00 00 00 00 00 |FOOTER..|........|
|000027d0| 00 00 00 00 05 00 00 00 | 0d 00 49 4e 53 45 52 54 |........|..INSERT|
|000027e0| 20 46 4f 4f 54 45 52 00 | 00 00 00 00 00 00 00 00 | FOOTER.|........|
|000027f0| 00 00 00 00 00 05 00 00 | 00 15 00 43 55 53 54 4f |........|...CUSTO|
|00002800| 4d 20 54 52 49 47 47 45 | 52 20 48 45 41 44 45 52 |M TRIGGE|R HEADER|
|00002810| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 05 00 |........|........|
|00002820| 00 00 15 00 43 55 53 54 | 4f 4d 20 54 52 49 47 47 |....CUST|OM TRIGG|
|00002830| 45 52 20 46 4f 4f 54 45 | 52 00 00 00 00 00 00 00 |ER FOOTE|R.......|
|00002840| 00 00 00 00 00 00 00 05 | 00 00 00 0d 00 49 4e 53 |........|.....INS|
|00002850| 45 52 54 20 46 4f 4f 54 | 45 52 00 00 00 00 00 00 |ERT FOOT|ER......|
|00002860| 00 00 00 00 00 00 00 00 | 05 00 00 00 15 00 43 55 |........|......CU|
|00002870| 53 54 4f 4d 20 54 52 49 | 47 47 45 52 20 48 45 41 |STOM TRI|GGER HEA|
|00002880| 44 45 52 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |DER.....|........|
|00002890| 00 05 00 00 00 15 00 43 | 55 53 54 4f 4d 20 54 52 |.......C|USTOM TR|
|000028a0| 49 47 47 45 52 20 46 4f | 4f 54 45 52 00 00 00 00 |IGGER FO|OTER....|
|000028b0| 00 00 00 00 00 00 00 00 | 00 00 05 00 00 00 0d 00 |........|........|
|000028c0| 49 4e 53 45 52 54 20 46 | 4f 4f 54 45 52 00 00 00 |INSERT F|OOTER...|
|000028d0| 00 00 00 00 00 00 00 00 | 00 00 00 05 00 00 00 15 |........|........|
|000028e0| 00 43 55 53 54 4f 4d 20 | 54 52 49 47 47 45 52 20 |.CUSTOM |TRIGGER |
|000028f0| 48 45 41 44 45 52 00 00 | 00 00 00 00 00 00 00 00 |HEADER..|........|
|00002900| 00 00 00 00 05 00 00 00 | 15 00 43 55 53 54 4f 4d |........|..CUSTOM|
|00002910| 20 54 52 49 47 47 45 52 | 20 46 4f 4f 54 45 52 00 | TRIGGER| FOOTER.|
|00002920| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 05 00 00 |........|........|
|00002930| 00 0d 00 49 4e 53 45 52 | 54 20 46 4f 4f 54 45 52 |...INSER|T FOOTER|
|00002940| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 05 00 |........|........|
|00002950| 00 00 15 00 43 55 53 54 | 4f 4d 20 54 52 49 47 47 |....CUST|OM TRIGG|
|00002960| 45 52 20 48 45 41 44 45 | 52 00 00 00 00 00 00 00 |ER HEADE|R.......|
|00002970| 00 00 00 00 00 00 00 05 | 00 00 00 15 00 43 55 53 |........|.....CUS|
|00002980| 54 4f 4d 20 54 52 49 47 | 47 45 52 20 46 4f 4f 54 |TOM TRIG|GER FOOT|
|00002990| 45 52 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |ER......|........|
|000029a0| 05 00 00 00 0d 00 49 4e | 53 45 52 54 20 46 4f 4f |......IN|SERT FOO|
|000029b0| 54 45 52 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |TER.....|........|
|000029c0| 00 05 00 00 00 15 00 43 | 55 53 54 4f 4d 20 54 52 |.......C|USTOM TR|
|000029d0| 49 47 47 45 52 20 48 45 | 41 44 45 52 00 00 00 00 |IGGER HE|ADER....|
|000029e0| 00 00 00 00 00 00 00 00 | 00 00 05 00 00 00 15 00 |........|........|
|000029f0| 43 55 53 54 4f 4d 20 54 | 52 49 47 47 45 52 20 46 |CUSTOM T|RIGGER F|
|00002a00| 4f 4f 54 45 52 00 00 00 | 00 00 00 00 00 00 00 00 |OOTER...|........|
|00002a10| 00 00 00 05 00 00 00 0d | 00 49 4e 53 45 52 54 20 |........|.INSERT |
|00002a20| 46 4f 4f 54 45 52 00 00 | 00 00 00 00 00 00 00 00 |FOOTER..|........|
|00002a30| 00 00 00 00 05 00 00 00 | 15 00 43 55 53 54 4f 4d |........|..CUSTOM|
|00002a40| 20 54 52 49 47 47 45 52 | 20 48 45 41 44 45 52 00 | TRIGGER| HEADER.|
|00002a50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 05 00 00 |........|........|
|00002a60| 00 15 00 43 55 53 54 4f | 4d 20 54 52 49 47 47 45 |...CUSTO|M TRIGGE|
|00002a70| 52 20 46 4f 4f 54 45 52 | 00 00 00 00 00 00 00 00 |R FOOTER|........|
|00002a80| 00 00 00 00 00 00 05 00 | 00 00 0d 00 49 4e 53 45 |........|....INSE|
|00002a90| 52 54 20 46 4f 4f 54 45 | 52 00 00 00 00 00 00 00 |RT FOOTE|R.......|
|00002aa0| 00 00 00 00 00 00 00 05 | 00 00 00 15 00 43 55 53 |........|.....CUS|
|00002ab0| 54 4f 4d 20 54 52 49 47 | 47 45 52 20 48 45 41 44 |TOM TRIG|GER HEAD|
|00002ac0| 45 52 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |ER......|........|
|00002ad0| 05 00 00 00 15 00 43 55 | 53 54 4f 4d 20 54 52 49 |......CU|STOM TRI|
|00002ae0| 47 47 45 52 20 46 4f 4f | 54 45 52 00 00 00 00 00 |GGER FOO|TER.....|
|00002af0| 00 00 00 00 00 00 00 00 | 00 05 00 00 00 1b 00 43 |........|.......C|
|00002b00| 55 53 54 4f 4d 20 54 52 | 49 47 47 45 52 20 44 45 |USTOM TR|IGGER DE|
|00002b10| 46 41 55 4c 54 20 42 4f | 44 59 d5 00 54 52 49 47 |FAULT BO|DY..TRIG|
|00002b20| 47 45 52 20 50 52 4f 43 | 45 44 55 52 45 20 46 4f |GER PROC|EDURE FO|
|00002b30| 52 20 25 41 63 74 69 6f | 6e 20 4f 46 20 25 54 61 |R %Actio|n OF %Ta|
|00002b40| 62 6c 65 4e 61 6d 65 2e | 0d 0a 20 20 25 52 65 66 |bleName.|.. %Ref|
|00002b50| 43 6c 61 75 73 65 0d 0a | 2f 2a 20 45 52 77 69 6e |Clause..|/* ERwin|
|00002b60| 20 42 75 69 6c 74 69 6e | 20 25 44 61 74 65 74 69 | Builtin| %Dateti|
|00002b70| 6d 65 20 2a 2f 0d 0a 2f | 2a 20 64 65 66 61 75 6c |me */../|* defaul|
|00002b80| 74 20 62 6f 64 79 20 66 | 6f 72 20 25 54 72 69 67 |t body f|or %Trig|
|00002b90| 67 65 72 4e 61 6d 65 20 | 2a 2f 0d 0a 25 46 6f 72 |gerName |*/..%For|
|00002ba0| 45 61 63 68 43 68 69 6c | 64 52 65 6c 28 29 20 7b |EachChil|dRel() {|
|00002bb0| 0d 0a 20 20 25 52 65 6c | 54 65 6d 70 6c 61 74 65 |.. %Rel|Template|
|00002bc0| 0d 0a 7d 0d 0a 25 46 6f | 72 45 61 63 68 50 61 72 |..}..%Fo|rEachPar|
|00002bd0| 65 6e 74 52 65 6c 28 29 | 20 7b 0d 0a 20 20 25 52 |entRel()| {.. %R|
|00002be0| 65 6c 54 65 6d 70 6c 61 | 74 65 0d 0a 7d 0d 0a 0d |elTempla|te..}...|
|00002bf0| 0a 30 27 00 00 00 00 00 | 00 00 00 00 00 05 00 00 |.0'.....|........|
|00002c00| 00 19 00 50 41 52 45 4e | 54 20 55 50 44 41 54 45 |...PAREN|T UPDATE|
|00002c10| 20 53 45 54 20 44 45 46 | 41 55 4c 54 92 00 2f 2a | SET DEF|AULT../*|
|00002c20| 20 45 52 77 69 6e 20 42 | 75 69 6c 74 69 6e 20 25 | ERwin B|uiltin %|
|00002c30| 44 61 74 65 74 69 6d 65 | 20 2a 2f 0d 0a 2f 2a 20 |Datetime| */../* |
|00002c40| 25 50 61 72 65 6e 74 20 | 25 56 65 72 62 50 68 72 |%Parent |%VerbPhr|
|00002c50| 61 73 65 20 25 43 68 69 | 6c 64 20 4f 4e 20 50 41 |ase %Chi|ld ON PA|
|00002c60| 52 45 4e 54 20 55 50 44 | 41 54 45 20 53 45 54 20 |RENT UPD|ATE SET |
|00002c70| 44 45 46 41 55 4c 54 20 | 2a 2f 0d 0a 2f 2a 20 41 |DEFAULT |*/../* A|
|00002c80| 70 70 6c 69 63 61 74 69 | 6f 6e 20 73 70 65 63 69 |pplicati|on speci|
|00002c90| 66 69 63 2e 20 20 4c 65 | 66 74 20 6f 75 74 20 69 |fic. Le|ft out i|
|00002ca0| 6e 74 65 6e 74 69 6f 6e | 61 6c 6c 79 2e 20 2a 2f |ntention|ally. */|
|00002cb0| 13 27 00 00 00 00 00 00 | 00 00 00 00 05 00 00 00 |.'......|........|
|00002cc0| 19 00 50 41 52 45 4e 54 | 20 44 45 4c 45 54 45 20 |..PARENT| DELETE |
|00002cd0| 53 45 54 20 44 45 46 41 | 55 4c 54 92 00 2f 2a 20 |SET DEFA|ULT../* |
|00002ce0| 45 52 77 69 6e 20 42 75 | 69 6c 74 69 6e 20 25 44 |ERwin Bu|iltin %D|
|00002cf0| 61 74 65 74 69 6d 65 20 | 2a 2f 0d 0a 2f 2a 20 25 |atetime |*/../* %|
|00002d00| 50 61 72 65 6e 74 20 25 | 56 65 72 62 50 68 72 61 |Parent %|VerbPhra|
|00002d10| 73 65 20 25 43 68 69 6c | 64 20 4f 4e 20 50 41 52 |se %Chil|d ON PAR|
|00002d20| 45 4e 54 20 44 45 4c 45 | 54 45 20 53 45 54 20 44 |ENT DELE|TE SET D|
|00002d30| 45 46 41 55 4c 54 20 2a | 2f 0d 0a 2f 2a 20 41 70 |EFAULT *|/../* Ap|
|00002d40| 70 6c 69 63 61 74 69 6f | 6e 20 73 70 65 63 69 66 |plicatio|n specif|
|00002d50| 69 63 2e 20 20 4c 65 66 | 74 20 6f 75 74 20 69 6e |ic. Lef|t out in|
|00002d60| 74 65 6e 74 69 6f 6e 61 | 6c 6c 79 2e 20 2a 2f 17 |tentiona|lly. */.|
|00002d70| 27 00 00 00 00 00 00 00 | 00 00 00 05 00 00 00 19 |'.......|........|
|00002d80| 00 50 41 52 45 4e 54 20 | 49 4e 53 45 52 54 20 53 |.PARENT |INSERT S|
|00002d90| 45 54 20 44 45 46 41 55 | 4c 54 92 00 2f 2a 20 45 |ET DEFAU|LT../* E|
|00002da0| 52 77 69 6e 20 42 75 69 | 6c 74 69 6e 20 25 44 61 |Rwin Bui|ltin %Da|
|00002db0| 74 65 74 69 6d 65 20 2a | 2f 0d 0a 2f 2a 20 25 50 |tetime *|/../* %P|
|00002dc0| 61 72 65 6e 74 20 25 56 | 65 72 62 50 68 72 61 73 |arent %V|erbPhras|
|00002dd0| 65 20 25 43 68 69 6c 64 | 20 4f 4e 20 50 41 52 45 |e %Child| ON PARE|
|00002de0| 4e 54 20 49 4e 53 45 52 | 54 20 53 45 54 20 44 45 |NT INSER|T SET DE|
|00002df0| 46 41 55 4c 54 20 2a 2f | 0d 0a 2f 2a 20 41 70 70 |FAULT */|../* App|
|00002e00| 6c 69 63 61 74 69 6f 6e | 20 73 70 65 63 69 66 69 |lication| specifi|
|00002e10| 63 2e 20 20 4c 65 66 74 | 20 6f 75 74 20 69 6e 74 |c. Left| out int|
|00002e20| 65 6e 74 69 6f 6e 61 6c | 6c 79 2e 20 2a 2f 27 27 |entional|ly. */''|
|00002e30| 00 00 00 00 00 00 00 00 | 00 00 05 00 00 00 18 00 |........|........|
|00002e40| 43 48 49 4c 44 20 49 4e | 53 45 52 54 20 53 45 54 |CHILD IN|SERT SET|
|00002e50| 20 44 45 46 41 55 4c 54 | 91 00 2f 2a 20 45 52 77 | DEFAULT|../* ERw|
|00002e60| 69 6e 20 42 75 69 6c 74 | 69 6e 20 25 44 61 74 65 |in Built|in %Date|
|00002e70| 74 69 6d 65 20 2a 2f 0d | 0a 2f 2a 20 25 50 61 72 |time */.|./* %Par|
|00002e80| 65 6e 74 20 25 56 65 72 | 62 50 68 72 61 73 65 20 |ent %Ver|bPhrase |
|00002e90| 25 43 68 69 6c 64 20 4f | 4e 20 43 48 49 4c 44 20 |%Child O|N CHILD |
|00002ea0| 49 4e 53 45 52 54 20 53 | 45 54 20 44 45 46 41 55 |INSERT S|ET DEFAU|
|00002eb0| 4c 54 20 2a 2f 0d 0a 2f | 2a 20 41 70 70 6c 69 63 |LT */../|* Applic|
|00002ec0| 61 74 69 6f 6e 20 73 70 | 65 63 69 66 69 63 2e 20 |ation sp|ecific. |
|00002ed0| 20 4c 65 66 74 20 6f 75 | 74 20 69 6e 74 65 6e 74 | Left ou|t intent|
|00002ee0| 69 6f 6e 61 6c 6c 79 2e | 20 2a 2f 1b 27 00 00 00 |ionally.| */.'...|
|00002ef0| 00 00 00 00 00 00 00 05 | 00 00 00 18 00 43 48 49 |........|.....CHI|
|00002f00| 4c 44 20 55 50 44 41 54 | 45 20 53 45 54 20 44 45 |LD UPDAT|E SET DE|
|00002f10| 46 41 55 4c 54 91 00 2f | 2a 20 45 52 77 69 6e 20 |FAULT../|* ERwin |
|00002f20| 42 75 69 6c 74 69 6e 20 | 25 44 61 74 65 74 69 6d |Builtin |%Datetim|
|00002f30| 65 20 2a 2f 0d 0a 2f 2a | 20 25 50 61 72 65 6e 74 |e */../*| %Parent|
|00002f40| 20 25 56 65 72 62 50 68 | 72 61 73 65 20 25 43 68 | %VerbPh|rase %Ch|
|00002f50| 69 6c 64 20 4f 4e 20 43 | 48 49 4c 44 20 55 50 44 |ild ON C|HILD UPD|
|00002f60| 41 54 45 20 53 45 54 20 | 44 45 46 41 55 4c 54 20 |ATE SET |DEFAULT |
|00002f70| 2a 2f 0d 0a 2f 2a 20 41 | 70 70 6c 69 63 61 74 69 |*/../* A|pplicati|
|00002f80| 6f 6e 20 73 70 65 63 69 | 66 69 63 2e 20 20 4c 65 |on speci|fic. Le|
|00002f90| 66 74 20 6f 75 74 20 69 | 6e 74 65 6e 74 69 6f 6e |ft out i|ntention|
|00002fa0| 61 6c 6c 79 2e 20 2a 2f | 1f 27 00 00 00 00 00 00 |ally. */|.'......|
|00002fb0| 00 00 00 00 05 00 00 00 | 18 00 43 48 49 4c 44 20 |........|..CHILD |
|00002fc0| 44 45 4c 45 54 45 20 53 | 45 54 20 44 45 46 41 55 |DELETE S|ET DEFAU|
|00002fd0| 4c 54 91 00 2f 2a 20 45 | 52 77 69 6e 20 42 75 69 |LT../* E|Rwin Bui|
|00002fe0| 6c 74 69 6e 20 25 44 61 | 74 65 74 69 6d 65 20 2a |ltin %Da|tetime *|
|00002ff0| 2f 0d 0a 2f 2a 20 25 50 | 61 72 65 6e 74 20 25 56 |/../* %P|arent %V|
|00003000| 65 72 62 50 68 72 61 73 | 65 20 25 43 68 69 6c 64 |erbPhras|e %Child|
|00003010| 20 4f 4e 20 43 48 49 4c | 44 20 44 45 4c 45 54 45 | ON CHIL|D DELETE|
|00003020| 20 53 45 54 20 44 45 46 | 41 55 4c 54 20 2a 2f 0d | SET DEF|AULT */.|
|00003030| 0a 2f 2a 20 41 70 70 6c | 69 63 61 74 69 6f 6e 20 |./* Appl|ication |
|00003040| 73 70 65 63 69 66 69 63 | 2e 20 20 4c 65 66 74 20 |specific|. Left |
|00003050| 6f 75 74 20 69 6e 74 65 | 6e 74 69 6f 6e 61 6c 6c |out inte|ntionall|
|00003060| 79 2e 20 2a 2f 23 27 00 | 00 00 00 00 00 00 00 00 |y. */#'.|........|
|00003070| 00 05 00 00 00 15 00 43 | 48 49 4c 44 20 44 45 4c |.......C|HILD DEL|
|00003080| 45 54 45 20 53 45 54 20 | 4e 55 4c 4c 8e 00 2f 2a |ETE SET |NULL../*|
|00003090| 20 45 52 77 69 6e 20 42 | 75 69 6c 74 69 6e 20 25 | ERwin B|uiltin %|
|000030a0| 44 61 74 65 74 69 6d 65 | 20 2a 2f 0d 0a 2f 2a 20 |Datetime| */../* |
|000030b0| 25 50 61 72 65 6e 74 20 | 25 56 65 72 62 50 68 72 |%Parent |%VerbPhr|
|000030c0| 61 73 65 20 25 43 68 69 | 6c 64 20 4f 4e 20 43 48 |ase %Chi|ld ON CH|
|000030d0| 49 4c 44 20 44 45 4c 45 | 54 45 20 53 45 54 20 4e |ILD DELE|TE SET N|
|000030e0| 55 4c 4c 20 2a 2f 0d 0a | 2f 2a 20 41 70 70 6c 69 |ULL */..|/* Appli|
|000030f0| 63 61 74 69 6f 6e 20 73 | 70 65 63 69 66 69 63 2e |cation s|pecific.|
|00003100| 20 20 4c 65 66 74 20 6f | 75 74 20 69 6e 74 65 6e | Left o|ut inten|
|00003110| 74 69 6f 6e 61 6c 6c 79 | 2e 20 2a 2f 22 27 00 00 |tionally|. */"'..|
|00003120| 00 00 00 00 00 00 00 00 | 05 00 00 00 16 00 50 41 |........|......PA|
|00003130| 52 45 4e 54 20 49 4e 53 | 45 52 54 20 53 45 54 20 |RENT INS|ERT SET |
|00003140| 4e 55 4c 4c 8f 00 2f 2a | 20 45 52 77 69 6e 20 42 |NULL../*| ERwin B|
|00003150| 75 69 6c 74 69 6e 20 25 | 44 61 74 65 74 69 6d 65 |uiltin %|Datetime|
|00003160| 20 2a 2f 0d 0a 2f 2a 20 | 25 50 61 72 65 6e 74 20 | */../* |%Parent |
|00003170| 25 56 65 72 62 50 68 72 | 61 73 65 20 25 43 68 69 |%VerbPhr|ase %Chi|
|00003180| 6c 64 20 4f 4e 20 50 41 | 52 45 4e 54 20 49 4e 53 |ld ON PA|RENT INS|
|00003190| 45 52 54 20 53 45 54 20 | 4e 55 4c 4c 20 2a 2f 0d |ERT SET |NULL */.|
|000031a0| 0a 2f 2a 20 41 70 70 6c | 69 63 61 74 69 6f 6e 20 |./* Appl|ication |
|000031b0| 73 70 65 63 69 66 69 63 | 2e 20 20 4c 65 66 74 20 |specific|. Left |
|000031c0| 6f 75 74 20 69 6e 74 65 | 6e 74 69 6f 6e 61 6c 6c |out inte|ntionall|
|000031d0| 79 2e 20 2a 2f 26 27 00 | 00 00 00 00 00 00 00 00 |y. */&'.|........|
|000031e0| 00 05 00 00 00 15 00 50 | 41 52 45 4e 54 20 49 4e |.......P|ARENT IN|
|000031f0| 53 45 52 54 20 43 41 53 | 43 41 44 45 8e 00 2f 2a |SERT CAS|CADE../*|
|00003200| 20 45 52 77 69 6e 20 42 | 75 69 6c 74 69 6e 20 25 | ERwin B|uiltin %|
|00003210| 44 61 74 65 74 69 6d 65 | 20 2a 2f 0d 0a 2f 2a 20 |Datetime| */../* |
|00003220| 25 50 61 72 65 6e 74 20 | 25 56 65 72 62 50 68 72 |%Parent |%VerbPhr|
|00003230| 61 73 65 20 25 43 68 69 | 6c 64 20 4f 4e 20 50 41 |ase %Chi|ld ON PA|
|00003240| 52 45 4e 54 20 49 4e 53 | 45 52 54 20 43 41 53 43 |RENT INS|ERT CASC|
|00003250| 41 44 45 20 2a 2f 0d 0a | 2f 2a 20 41 70 70 6c 69 |ADE */..|/* Appli|
|00003260| 63 61 74 69 6f 6e 20 73 | 70 65 63 69 66 69 63 2e |cation s|pecific.|
|00003270| 20 20 4c 65 66 74 20 6f | 75 74 20 69 6e 74 65 6e | Left o|ut inten|
|00003280| 74 69 6f 6e 61 6c 6c 79 | 2e 20 2a 2f 25 27 00 00 |tionally|. */%'..|
|00003290| 00 00 00 00 00 00 00 00 | 02 00 00 00 03 00 0d 00 |........|........|
|000032a0| 54 65 6d 70 6c 61 74 65 | 20 4e 61 6d 65 22 00 00 |Template| Name"..|
|000032b0| 00 00 02 00 0f 00 54 65 | 6d 70 6c 61 74 65 20 48 |......Te|mplate H|
|000032c0| 61 6e 64 6c 65 00 00 00 | 00 00 00 00 00 00 03 00 |andle...|........|
|000032d0| 00 00 01 00 0c 00 50 75 | 72 70 6f 73 65 20 54 65 |......Pu|rpose Te|
|000032e0| 78 74 22 00 00 00 00 00 | 00 07 00 50 75 72 70 6f |xt".....|...Purpo|
|000032f0| 73 65 00 00 00 00 00 02 | 00 0f 00 54 65 6d 70 6c |se......|...Templ|
|00003300| 61 74 65 20 48 61 6e 64 | 6c 65 22 00 00 00 00 22 |ate Hand|le"...."|
|00003310| 00 00 00 03 00 00 00 14 | 00 43 48 49 4c 44 20 44 |........|.CHILD D|
|00003320| 45 4c 45 54 45 20 43 41 | 53 43 41 44 45 21 27 00 |ELETE CA|SCADE!'.|
|00003330| 00 21 27 ff ff 03 00 00 | 00 15 00 43 48 49 4c 44 |.!'.....|...CHILD|
|00003340| 20 44 45 4c 45 54 45 20 | 52 45 53 54 52 49 43 54 | DELETE |RESTRICT|
|00003350| 20 27 00 00 20 27 ff ff | 03 00 00 00 18 00 43 48 | '.. '..|......CH|
|00003360| 49 4c 44 20 44 45 4c 45 | 54 45 20 53 45 54 20 44 |ILD DELE|TE SET D|
|00003370| 45 46 41 55 4c 54 23 27 | 00 00 23 27 ff ff 03 00 |EFAULT#'|..#'....|
|00003380| 00 00 15 00 43 48 49 4c | 44 20 44 45 4c 45 54 45 |....CHIL|D DELETE|
|00003390| 20 53 45 54 20 4e 55 4c | 4c 22 27 00 00 22 27 ff | SET NUL|L"'.."'.|
|000033a0| ff 03 00 00 00 14 00 43 | 48 49 4c 44 20 49 4e 53 |.......C|HILD INS|
|000033b0| 45 52 54 20 43 41 53 43 | 41 44 45 19 27 00 00 19 |ERT CASC|ADE.'...|
|000033c0| 27 ff ff 03 00 00 00 15 | 00 43 48 49 4c 44 20 49 |'.......|.CHILD I|
|000033d0| 4e 53 45 52 54 20 52 45 | 53 54 52 49 43 54 18 27 |NSERT RE|STRICT.'|
|000033e0| 00 00 18 27 ff ff 03 00 | 00 00 18 00 43 48 49 4c |...'....|....CHIL|
|000033f0| 44 20 49 4e 53 45 52 54 | 20 53 45 54 20 44 45 46 |D INSERT| SET DEF|
|00003400| 41 55 4c 54 1b 27 00 00 | 1b 27 ff ff 03 00 00 00 |AULT.'..|.'......|
|00003410| 15 00 43 48 49 4c 44 20 | 49 4e 53 45 52 54 20 53 |..CHILD |INSERT S|
|00003420| 45 54 20 4e 55 4c 4c 1a | 27 00 00 1a 27 ff ff 03 |ET NULL.|'...'...|
|00003430| 00 00 00 14 00 43 48 49 | 4c 44 20 55 50 44 41 54 |.....CHI|LD UPDAT|
|00003440| 45 20 43 41 53 43 41 44 | 45 1d 27 00 00 1d 27 ff |E CASCAD|E.'...'.|
|00003450| ff 03 00 00 00 15 00 43 | 48 49 4c 44 20 55 50 44 |.......C|HILD UPD|
|00003460| 41 54 45 20 52 45 53 54 | 52 49 43 54 1c 27 00 00 |ATE REST|RICT.'..|
|00003470| 1c 27 ff ff 03 00 00 00 | 18 00 43 48 49 4c 44 20 |.'......|..CHILD |
|00003480| 55 50 44 41 54 45 20 53 | 45 54 20 44 45 46 41 55 |UPDATE S|ET DEFAU|
|00003490| 4c 54 1f 27 00 00 1f 27 | ff ff 03 00 00 00 15 00 |LT.'...'|........|
|000034a0| 43 48 49 4c 44 20 55 50 | 44 41 54 45 20 53 45 54 |CHILD UP|DATE SET|
|000034b0| 20 4e 55 4c 4c 1e 27 00 | 00 1e 27 ff ff 03 00 00 | NULL.'.|..'.....|
|000034c0| 00 1b 00 43 55 53 54 4f | 4d 20 54 52 49 47 47 45 |...CUSTO|M TRIGGE|
|000034d0| 52 20 44 45 46 41 55 4c | 54 20 42 4f 44 59 30 27 |R DEFAUL|T BODY0'|
|000034e0| 00 00 30 27 ff ff 03 00 | 00 00 15 00 43 55 53 54 |..0'....|....CUST|
|000034f0| 4f 4d 20 54 52 49 47 47 | 45 52 20 46 4f 4f 54 45 |OM TRIGG|ER FOOTE|
|00003500| 52 2f 27 00 00 00 00 ff | ff 03 00 00 00 15 00 43 |R/'.....|.......C|
|00003510| 55 53 54 4f 4d 20 54 52 | 49 47 47 45 52 20 48 45 |USTOM TR|IGGER HE|
|00003520| 41 44 45 52 2e 27 00 00 | 00 00 ff ff 03 00 00 00 |ADER.'..|........|
|00003530| 15 00 50 41 52 45 4e 54 | 20 44 45 4c 45 54 45 20 |..PARENT| DELETE |
|00003540| 43 41 53 43 41 44 45 15 | 27 00 00 15 27 ff ff 03 |CASCADE.|'...'...|
|00003550| 00 00 00 16 00 50 41 52 | 45 4e 54 20 44 45 4c 45 |.....PAR|ENT DELE|
|00003560| 54 45 20 52 45 53 54 52 | 49 43 54 14 27 00 00 14 |TE RESTR|ICT.'...|
|00003570| 27 ff ff 03 00 00 00 19 | 00 50 41 52 45 4e 54 20 |'.......|.PARENT |
|00003580| 44 45 4c 45 54 45 20 53 | 45 54 20 44 45 46 41 55 |DELETE S|ET DEFAU|
|00003590| 4c 54 17 27 00 00 17 27 | ff ff 03 00 00 00 16 00 |LT.'...'|........|
|000035a0| 50 41 52 45 4e 54 20 44 | 45 4c 45 54 45 20 53 45 |PARENT D|ELETE SE|
|000035b0| 54 20 4e 55 4c 4c 16 27 | 00 00 16 27 ff ff 03 00 |T NULL.'|...'....|
|000035c0| 00 00 15 00 50 41 52 45 | 4e 54 20 49 4e 53 45 52 |....PARE|NT INSER|
|000035d0| 54 20 43 41 53 43 41 44 | 45 25 27 00 00 25 27 ff |T CASCAD|E%'..%'.|
|000035e0| ff 03 00 00 00 16 00 50 | 41 52 45 4e 54 20 49 4e |.......P|ARENT IN|
|000035f0| 53 45 52 54 20 52 45 53 | 54 52 49 43 54 24 27 00 |SERT RES|TRICT$'.|
|00003600| 00 24 27 ff ff 03 00 00 | 00 19 00 50 41 52 45 4e |.$'.....|...PAREN|
|00003610| 54 20 49 4e 53 45 52 54 | 20 53 45 54 20 44 45 46 |T INSERT| SET DEF|
|00003620| 41 55 4c 54 27 27 00 00 | 27 27 ff ff 03 00 00 00 |AULT''..|''......|
|00003630| 16 00 50 41 52 45 4e 54 | 20 49 4e 53 45 52 54 20 |..PARENT| INSERT |
|00003640| 53 45 54 20 4e 55 4c 4c | 26 27 00 00 26 27 ff ff |SET NULL|&'..&'..|
|00003650| 03 00 00 00 15 00 50 41 | 52 45 4e 54 20 55 50 44 |......PA|RENT UPD|
|00003660| 41 54 45 20 43 41 53 43 | 41 44 45 11 27 00 00 11 |ATE CASC|ADE.'...|
|00003670| 27 ff ff 03 00 00 00 16 | 00 50 41 52 45 4e 54 20 |'.......|.PARENT |
|00003680| 55 50 44 41 54 45 20 52 | 45 53 54 52 49 43 54 10 |UPDATE R|ESTRICT.|
|00003690| 27 00 00 10 27 ff ff 03 | 00 00 00 19 00 50 41 52 |'...'...|.....PAR|
|000036a0| 45 4e 54 20 55 50 44 41 | 54 45 20 53 45 54 20 44 |ENT UPDA|TE SET D|
|000036b0| 45 46 41 55 4c 54 13 27 | 00 00 13 27 ff ff 03 00 |EFAULT.'|...'....|
|000036c0| 00 00 16 00 50 41 52 45 | 4e 54 20 55 50 44 41 54 |....PARE|NT UPDAT|
|000036d0| 45 20 53 45 54 20 4e 55 | 4c 4c 12 27 00 00 12 27 |E SET NU|LL.'...'|
|000036e0| ff ff 03 00 00 00 14 00 | 52 41 49 53 45 20 45 58 |........|RAISE EX|
|000036f0| 43 45 50 54 49 4f 4e 20 | 50 52 4f 43 31 27 00 00 |CEPTION |PROC1'..|
|00003700| 00 00 ff ff 03 00 00 00 | 15 00 54 52 49 47 47 45 |........|..TRIGGE|
|00003710| 52 20 44 45 4c 45 54 45 | 20 46 4f 4f 54 45 52 2b |R DELETE| FOOTER+|
|00003720| 27 00 00 2b 27 ff ff 03 | 00 00 00 15 00 54 52 49 |'..+'...|.....TRI|
|00003730| 47 47 45 52 20 44 45 4c | 45 54 45 20 48 45 41 44 |GGER DEL|ETE HEAD|
|00003740| 45 52 2a 27 00 00 2a 27 | ff ff 03 00 00 00 15 00 |ER*'..*'|........|
|00003750| 54 52 49 47 47 45 52 20 | 49 4e 53 45 52 54 20 46 |TRIGGER |INSERT F|
|00003760| 4f 4f 54 45 52 2d 27 00 | 00 00 00 ff ff 03 00 00 |OOTER-'.|........|
|00003770| 00 15 00 54 52 49 47 47 | 45 52 20 49 4e 53 45 52 |...TRIGG|ER INSER|
|00003780| 54 20 48 45 41 44 45 52 | 2c 27 00 00 2c 27 ff ff |T HEADER|,'..,'..|
|00003790| 03 00 00 00 15 00 54 52 | 49 47 47 45 52 20 55 50 |......TR|IGGER UP|
|000037a0| 44 41 54 45 20 46 4f 4f | 54 45 52 29 27 00 00 29 |DATE FOO|TER)'..)|
|000037b0| 27 ff ff 03 00 00 00 15 | 00 54 52 49 47 47 45 52 |'.......|.TRIGGER|
|000037c0| 20 55 50 44 41 54 45 20 | 48 45 41 44 45 52 28 27 | UPDATE |HEADER('|
|000037d0| 00 00 28 27 ff ff 06 00 | 00 00 01 00 00 00 23 00 |..('....|......#.|
|000037e0| 00 00 00 01 00 00 00 40 | 00 00 00 00 00 00 00 00 |.......@|........|
|000037f0| 09 00 00 00 00 04 00 00 | 00 00 00 00 00 00 04 00 |........|........|
|00003800| 00 00 00 00 00 00 00 02 | 00 00 00 00 00 00 00 00 |........|........|
|00003810| 01 00 00 00 06 00 00 00 | 07 00 61 73 73 74 61 74 |........|..asstat|
|00003820| 65 c4 02 2f 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |e../****|********|
|00003830| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00003840| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00003850| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00003860| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 5c |********|*******\|
|00003870| 0d 0a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |..******|********|
|00003880| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00003890| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000038a0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000038b0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 0d |********|*******.|
|000038c0| 0a 2a 2a 0d 0a 2a 2a 20 | 20 20 20 20 50 72 6f 67 |.**..** | Prog|
|000038d0| 72 61 6d 3a 20 61 73 73 | 74 61 74 65 2e 70 0d 0a |ram: ass|tate.p..|
|000038e0| 2a 2a 20 20 20 20 44 65 | 73 63 72 69 70 74 3a 20 |** De|script: |
|000038f0| 54 6f 20 74 65 73 74 2c | 20 65 6e 74 65 72 20 61 |To test,| enter a|
|00003900| 6e 20 49 6e 76 61 6c 69 | 64 20 54 77 6f 2d 43 68 |n Invali|d Two-Ch|
|00003910| 61 72 61 63 74 65 72 20 | 53 74 61 74 65 20 41 62 |aracter |State Ab|
|00003920| 62 72 65 76 2e 0d 0a 2a | 2a 0d 0a 2a 2a 2a 2a 2a |brev...*|*..*****|
|00003930| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00003940| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00003950| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00003960| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00003970| 2a 2a 2a 2a 2a 2a 2a 2a | 0d 0a 5c 2a 2a 2a 2a 2a |********|..\*****|
|00003980| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00003990| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000039a0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000039b0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000039c0| 2a 2a 2a 2a 2a 2a 2f 0d | 0a 0d 0a 54 52 49 47 47 |******/.|...TRIGG|
|000039d0| 45 52 20 50 52 4f 43 45 | 44 55 52 45 20 46 4f 52 |ER PROCE|DURE FOR|
|000039e0| 20 41 73 73 69 67 6e 20 | 4f 46 20 43 75 73 74 6f | Assign |OF Custo|
|000039f0| 6d 65 72 2e 53 74 61 74 | 65 2e 0d 0a 20 20 0d 0a |mer.Stat|e... ..|
|00003a00| 49 46 20 43 75 73 74 6f | 6d 65 72 2e 43 6f 75 6e |IF Custo|mer.Coun|
|00003a10| 74 72 79 20 3d 20 22 55 | 53 41 22 20 41 4e 44 20 |try = "U|SA" AND |
|00003a20| 4e 4f 54 20 28 43 41 4e | 2d 46 49 4e 44 28 53 74 |NOT (CAN|-FIND(St|
|00003a30| 61 74 65 20 4f 46 20 43 | 75 73 74 6f 6d 65 72 29 |ate OF C|ustomer)|
|00003a40| 29 20 0d 0a 54 48 45 4e | 20 44 4f 3a 0d 0a 20 20 |) ..THEN| DO:.. |
|00003a50| 20 4d 45 53 53 41 47 45 | 20 22 49 6c 6c 65 67 61 | MESSAGE| "Illega|
|00003a60| 6c 20 53 74 61 74 65 20 | 6e 61 6d 65 20 66 6f 72 |l State |name for|
|00003a70| 20 74 68 65 20 55 2e 53 | 2e 41 2e 22 20 0d 0a 09 | the U.S|.A." ...|
|00003a80| 20 20 20 56 49 45 57 2d | 41 53 20 41 4c 45 52 54 | VIEW-|AS ALERT|
|00003a90| 2d 42 4f 58 20 49 4e 46 | 4f 52 4d 41 54 49 4f 4e |-BOX INF|ORMATION|
|00003aa0| 20 42 55 54 54 4f 4e 53 | 20 4f 4b 2e 0d 0a 20 20 | BUTTONS| OK... |
|00003ab0| 20 52 45 54 55 52 4e 20 | 45 52 52 4f 52 2e 20 20 | RETURN |ERROR. |
|00003ac0| 20 20 20 0d 0a 45 4e 44 | 2e 0d 0a 0d 0a 0d 0a 0d | ..END|........|
|00003ad0| 0a 0d 0a 0d 0a 0d 0a 0d | 0a 0d 0a 0d 0a 0d 0a 0d |........|........|
|00003ae0| 0a 0d 0a 0d 0a 0d 0a 00 | 00 00 00 02 00 00 00 00 |........|........|
|00003af0| 00 00 00 00 00 00 00 01 | 00 00 00 02 00 00 00 00 |........|........|
|00003b00| 00 00 00 00 00 00 00 00 | 06 00 00 00 01 00 00 00 |........|........|
|00003b10| 23 00 00 00 00 01 00 00 | 00 40 00 00 00 00 00 00 |#.......|.@......|
|00003b20| 00 00 09 00 00 00 00 04 | 00 00 00 00 00 00 00 00 |........|........|
|00003b30| 04 00 00 00 00 00 00 00 | 00 02 00 00 00 00 00 00 |........|........|
|00003b40| 00 00 00 00 00 00 06 00 | 00 00 01 00 00 00 1a 00 |........|........|
|00003b50| 00 00 00 01 00 00 00 40 | 00 00 00 00 00 00 00 00 |.......@|........|
|00003b60| 09 00 00 00 00 04 00 00 | 00 00 00 00 00 00 04 00 |........|........|
|00003b70| 00 00 00 00 00 00 00 02 | 00 00 00 00 00 00 00 00 |........|........|
|00003b80| 0e 00 00 00 06 00 00 00 | 1a 00 76 2d 73 69 6e 67 |........|..v-sing|
|00003b90| 6c 65 2d 74 61 62 6c 65 | 2d 61 6c 6c 2d 63 6f 6c |le-table|-all-col|
|00003ba0| 75 6d 6e 73 c4 23 25 44 | 65 63 6c 28 6d 79 64 62 |umns.#%D|ecl(mydb|
|00003bb0| 29 0d 0a 25 3d 28 6d 79 | 64 62 2c 44 42 5f 4e 41 |)..%=(my|db,DB_NA|
|00003bc0| 4d 45 29 0d 0a 25 46 6f | 72 45 61 63 68 45 6e 74 |ME)..%Fo|rEachEnt|
|00003bd0| 69 74 79 28 29 20 7b 25 | 44 65 63 6c 28 69 2c 30 |ity() {%|Decl(i,0|
|00003be0| 29 0d 0a 25 46 69 6c 65 | 28 27 64 3a 5c 64 6c 63 |)..%File|('d:\dlc|
|00003bf0| 5c 64 65 6d 6f 5c 76 2d | 73 61 6c 6c 2d 25 54 61 |\demo\v-|sall-%Ta|
|00003c00| 62 6c 65 4e 61 6d 65 2e | 77 27 29 7b 26 41 4e 41 |bleName.|w'){&ANA|
|00003c10| 4c 59 5a 45 2d 53 55 53 | 50 45 4e 44 20 5f 56 45 |LYZE-SUS|PEND _VE|
|00003c20| 52 53 49 4f 4e 2d 4e 55 | 4d 42 45 52 20 55 49 42 |RSION-NU|MBER UIB|
|00003c30| 5f 76 38 72 32 20 47 55 | 49 0d 0a 26 41 4e 41 4c |_v8r2 GU|I..&ANAL|
|00003c40| 59 5a 45 2d 52 45 53 55 | 4d 45 0d 0a 2f 2a 20 43 |YZE-RESU|ME../* C|
|00003c50| 6f 6e 6e 65 63 74 65 64 | 20 44 61 74 61 62 61 73 |onnected| Databas|
|00003c60| 65 73 0d 0a 2a 2f 0d 0a | 26 53 63 6f 70 65 64 2d |es..*/..|&Scoped-|
|00003c70| 64 65 66 69 6e 65 20 57 | 49 4e 44 4f 57 2d 4e 41 |define W|INDOW-NA|
|00003c80| 4d 45 20 43 55 52 52 45 | 4e 54 2d 57 49 4e 44 4f |ME CURRE|NT-WINDO|
|00003c90| 57 0d 0a 26 41 4e 41 4c | 59 5a 45 2d 53 55 53 50 |W..&ANAL|YZE-SUSP|
|00003ca0| 45 4e 44 20 5f 55 49 42 | 2d 43 4f 44 45 2d 42 4c |END _UIB|-CODE-BL|
|00003cb0| 4f 43 4b 20 5f 43 55 53 | 54 4f 4d 20 5f 44 45 46 |OCK _CUS|TOM _DEF|
|00003cc0| 49 4e 49 54 49 4f 4e 53 | 20 56 2d 74 61 62 6c 65 |INITIONS| V-table|
|00003cd0| 2d 57 69 6e 20 0d 0a 2f | 2a 2d 2d 2d 2d 2d 2d 2d |-Win ../|*-------|
|00003ce0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00003cf0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00003d00| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00003d10| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00003d20| 2d 0d 0a 0d 0a 20 20 46 | 69 6c 65 3a 0d 0a 0d 0a |-.... F|ile:....|
|00003d30| 20 20 44 65 73 63 72 69 | 70 74 69 6f 6e 3a 20 66 | Descri|ption: f|
|00003d40| 72 6f 6d 20 56 49 45 57 | 45 52 2e 57 20 2d 20 54 |rom VIEW|ER.W - T|
|00003d50| 65 6d 70 6c 61 74 65 20 | 66 6f 72 20 53 6d 61 72 |emplate |for Smar|
|00003d60| 74 56 69 65 77 65 72 20 | 4f 62 6a 65 63 74 73 0d |tViewer |Objects.|
|00003d70| 0a 0d 0a 20 20 49 6e 70 | 75 74 20 50 61 72 61 6d |... Inp|ut Param|
|00003d80| 65 74 65 72 73 3a 0d 0a | 20 20 20 20 20 20 3c 6e |eters:..| <n|
|00003d90| 6f 6e 65 3e 0d 0a 0d 0a | 20 20 4f 75 74 70 75 74 |one>....| Output|
|00003da0| 20 50 61 72 61 6d 65 74 | 65 72 73 3a 0d 0a 20 20 | Paramet|ers:.. |
|00003db0| 20 20 20 20 3c 6e 6f 6e | 65 3e 0d 0a 0d 0a 2d 2d | <non|e>....--|
|00003dc0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00003dd0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00003de0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00003df0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00003e00| 2d 2d 2d 2d 2d 2d 2a 2f | 0d 0a 2f 2a 20 20 20 20 |------*/|../* |
|00003e10| 20 20 20 20 20 20 54 68 | 69 73 20 2e 57 20 66 69 | Th|is .W fi|
|00003e20| 6c 65 20 77 61 73 20 63 | 72 65 61 74 65 64 20 77 |le was c|reated w|
|00003e30| 69 74 68 20 45 52 77 69 | 6e 20 32 2e 36 2e 20 20 |ith ERwi|n 2.6. |
|00003e40| 20 20 20 20 20 20 20 20 | 20 20 20 2a 2f 0d 0a 2f | | */../|
|00003e50| 2a 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |*-------|--------|
|00003e60| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00003e70| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00003e80| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00003e90| 2d 2d 2d 2d 2d 2d 2d 2a | 2f 0d 0a 0d 0a 2f 2a 20 |-------*|/..../* |
|00003ea0| 43 72 65 61 74 65 20 61 | 6e 20 75 6e 6e 61 6d 65 |Create a|n unname|
|00003eb0| 64 20 70 6f 6f 6c 20 74 | 6f 20 73 74 6f 72 65 20 |d pool t|o store |
|00003ec0| 61 6c 6c 20 74 68 65 20 | 77 69 64 67 65 74 73 20 |all the |widgets |
|00003ed0| 63 72 65 61 74 65 64 20 | 0d 0a 20 20 20 20 20 62 |created |.. b|
|00003ee0| 79 20 74 68 69 73 20 70 | 72 6f 63 65 64 75 72 65 |y this p|rocedure|
|00003ef0| 2e 20 54 68 69 73 20 69 | 73 20 61 20 67 6f 6f 64 |. This i|s a good|
|00003f00| 20 64 65 66 61 75 6c 74 | 20 77 68 69 63 68 20 61 | default| which a|
|00003f10| 73 73 75 72 65 73 0d 0a | 20 20 20 20 20 74 68 61 |ssures..| tha|
|00003f20| 74 20 74 68 69 73 20 70 | 72 6f 63 65 64 75 72 65 |t this p|rocedure|
|00003f30| 27 73 20 74 72 69 67 67 | 65 72 73 20 61 6e 64 20 |'s trigg|ers and |
|00003f40| 69 6e 74 65 72 6e 61 6c | 20 70 72 6f 63 65 64 75 |internal| procedu|
|00003f50| 72 65 73 20 0d 0a 20 20 | 20 20 20 77 69 6c 6c 20 |res .. | will |
|00003f60| 65 78 65 63 75 74 65 20 | 69 6e 20 74 68 69 73 20 |execute |in this |
|00003f70| 70 72 6f 63 65 64 75 72 | 65 27 73 20 73 74 6f 72 |procedur|e's stor|
|00003f80| 61 67 65 2c 20 61 6e 64 | 20 74 68 61 74 20 70 72 |age, and| that pr|
|00003f90| 6f 70 65 72 0d 0a 20 20 | 20 20 20 63 6c 65 61 6e |oper.. | clean|
|00003fa0| 75 70 20 77 69 6c 6c 20 | 6f 63 63 75 72 20 6f 6e |up will |occur on|
|00003fb0| 20 64 65 6c 65 74 69 6f | 6e 20 6f 66 20 74 68 65 | deletio|n of the|
|00003fc0| 20 70 72 6f 63 65 64 75 | 72 65 2e 20 2a 2f 0d 0a | procedu|re. */..|
|00003fd0| 0d 0a 43 52 45 41 54 45 | 20 57 49 44 47 45 54 2d |..CREATE| WIDGET-|
|00003fe0| 50 4f 4f 4c 2e 0d 0a 0d | 0a 2f 2a 20 2a 2a 2a 2a |POOL....|./* ****|
|00003ff0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004000| 2a 2a 2a 2a 2a 2a 2a 20 | 20 44 65 66 69 6e 69 74 |******* | Definit|
|00004010| 69 6f 6e 73 20 20 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |ions **|********|
|00004020| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004030| 20 2a 2f 0d 0a 0d 0a 2f | 2a 20 50 61 72 61 6d 65 | */..../|* Parame|
|00004040| 74 65 72 73 20 44 65 66 | 69 6e 69 74 69 6f 6e 73 |ters Def|initions|
|00004050| 20 2d 2d 2d 20 20 20 20 | 20 20 20 20 20 20 20 20 | --- | |
|00004060| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004070| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 2a | | *|
|00004080| 2f 0d 0a 0d 0a 2f 2a 20 | 4c 6f 63 61 6c 20 56 61 |/..../* |Local Va|
|00004090| 72 69 61 62 6c 65 20 44 | 65 66 69 6e 69 74 69 6f |riable D|efinitio|
|000040a0| 6e 73 20 2d 2d 2d 20 20 | 20 20 20 20 20 20 20 20 |ns --- | |
|000040b0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000040c0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 2a 2f 0d | | */.|
|000040d0| 0a 0d 0a 2f 2a 20 5f 55 | 49 42 2d 43 4f 44 45 2d |.../* _U|IB-CODE-|
|000040e0| 42 4c 4f 43 4b 2d 45 4e | 44 20 2a 2f 0d 0a 26 41 |BLOCK-EN|D */..&A|
|000040f0| 4e 41 4c 59 5a 45 2d 52 | 45 53 55 4d 45 0d 0a 0d |NALYZE-R|ESUME...|
|00004100| 0a 0d 0a 26 41 4e 41 4c | 59 5a 45 2d 53 55 53 50 |...&ANAL|YZE-SUSP|
|00004110| 45 4e 44 20 5f 55 49 42 | 2d 50 52 45 50 52 4f 43 |END _UIB|-PREPROC|
|00004120| 45 53 53 4f 52 2d 42 4c | 4f 43 4b 20 0d 0a 0d 0a |ESSOR-BL|OCK ....|
|00004130| 2f 2a 20 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |/* *****|********|
|00004140| 2a 2a 2a 2a 2a 2a 2a 20 | 20 50 72 65 70 72 6f 63 |******* | Preproc|
|00004150| 65 73 73 6f 72 20 44 65 | 66 69 6e 69 74 69 6f 6e |essor De|finition|
|00004160| 73 20 20 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |s *****|********|
|00004170| 2a 2a 2a 2a 2a 2a 2a 20 | 2a 2f 0d 0a 0d 0a 26 53 |******* |*/....&S|
|00004180| 63 6f 70 65 64 2d 64 65 | 66 69 6e 65 20 50 52 4f |coped-de|fine PRO|
|00004190| 43 45 44 55 52 45 2d 54 | 59 50 45 20 53 6d 61 72 |CEDURE-T|YPE Smar|
|000041a0| 74 56 69 65 77 65 72 0d | 0a 0d 0a 26 53 63 6f 70 |tViewer.|...&Scop|
|000041b0| 65 64 2d 64 65 66 69 6e | 65 20 41 44 4d 2d 53 55 |ed-defin|e ADM-SU|
|000041c0| 50 50 4f 52 54 45 44 2d | 4c 49 4e 4b 53 20 52 65 |PPORTED-|LINKS Re|
|000041d0| 63 6f 72 64 2d 53 6f 75 | 72 63 65 2c 52 65 63 6f |cord-Sou|rce,Reco|
|000041e0| 72 64 2d 54 61 72 67 65 | 74 2c 54 61 62 6c 65 49 |rd-Targe|t,TableI|
|000041f0| 4f 2d 54 61 72 67 65 74 | 0d 0a 0d 0a 2f 2a 20 4e |O-Target|..../* N|
|00004200| 61 6d 65 20 6f 66 20 66 | 69 72 73 74 20 46 72 61 |ame of f|irst Fra|
|00004210| 6d 65 20 61 6e 64 2f 6f | 72 20 42 72 6f 77 73 65 |me and/o|r Browse|
|00004220| 20 61 6e 64 2f 6f 72 20 | 66 69 72 73 74 20 51 75 | and/or |first Qu|
|00004230| 65 72 79 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |ery | |
|00004240| 20 20 20 20 2a 2f 0d 0a | 26 53 63 6f 70 65 64 2d | */..|&Scoped-|
|00004250| 64 65 66 69 6e 65 20 46 | 52 41 4d 45 2d 4e 41 4d |define F|RAME-NAM|
|00004260| 45 20 46 2d 4d 61 69 6e | 0d 0a 0d 0a 2f 2a 20 45 |E F-Main|..../* E|
|00004270| 78 74 65 72 6e 61 6c 20 | 54 61 62 6c 65 73 20 20 |xternal |Tables |
|00004280| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004290| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000042a0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000042b0| 20 20 20 20 2a 2f 0d 0a | 26 53 63 6f 70 65 64 2d | */..|&Scoped-|
|000042c0| 64 65 66 69 6e 65 20 46 | 49 52 53 54 2d 45 58 54 |define F|IRST-EXT|
|000042d0| 45 52 4e 41 4c 2d 54 41 | 42 4c 45 20 25 54 61 62 |ERNAL-TA|BLE %Tab|
|000042e0| 6c 65 4e 61 6d 65 0d 0a | 26 53 63 6f 70 65 64 2d |leName..|&Scoped-|
|000042f0| 64 65 66 69 6e 65 20 45 | 58 54 45 52 4e 41 4c 2d |define E|XTERNAL-|
|00004300| 54 41 42 4c 45 53 20 25 | 54 61 62 6c 65 4e 61 6d |TABLES %|TableNam|
|00004310| 65 0d 0a 2f 2a 20 4e 65 | 65 64 20 74 6f 20 73 63 |e../* Ne|ed to sc|
|00004320| 6f 70 65 20 74 68 65 20 | 65 78 74 65 72 6e 61 6c |ope the |external|
|00004330| 20 74 61 62 6c 65 73 20 | 74 6f 20 74 68 69 73 20 | tables |to this |
|00004340| 70 72 6f 63 65 64 75 72 | 65 20 20 20 20 20 20 20 |procedur|e |
|00004350| 20 20 20 20 20 20 20 20 | 20 20 20 2a 2f 0d 0a 44 | | */..D|
|00004360| 45 46 49 4e 45 20 51 55 | 45 52 59 20 65 78 74 65 |EFINE QU|ERY exte|
|00004370| 72 6e 61 6c 5f 74 61 62 | 6c 65 73 20 46 4f 52 20 |rnal_tab|les FOR |
|00004380| 25 54 61 62 6c 65 4e 61 | 6d 65 2e 0d 0a 0d 0a 2f |%TableNa|me...../|
|00004390| 2a 20 53 74 61 6e 64 61 | 72 64 20 4c 69 73 74 20 |* Standa|rd List |
|000043a0| 44 65 66 69 6e 69 74 69 | 6f 6e 73 20 20 20 20 20 |Definiti|ons |
|000043b0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000043c0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000043d0| 20 20 20 20 20 20 20 2a | 2f 0d 0a 26 53 63 6f 70 | *|/..&Scop|
|000043e0| 65 64 2d 44 65 66 69 6e | 65 20 45 4e 41 42 4c 45 |ed-Defin|e ENABLE|
|000043f0| 44 2d 46 49 45 4c 44 53 | 20 25 46 6f 72 45 61 63 |D-FIELDS| %ForEac|
|00004400| 68 41 74 74 28 2c 29 7b | 25 54 61 62 6c 65 4e 61 |hAtt(,){|%TableNa|
|00004410| 6d 65 2e 25 41 74 74 46 | 69 65 6c 64 4e 61 6d 65 |me.%AttF|ieldName|
|00004420| 20 7d 0d 0a 26 53 63 6f | 70 65 64 2d 64 65 66 69 | }..&Sco|ped-defi|
|00004430| 6e 65 20 46 49 45 4c 44 | 2d 50 41 49 52 53 20 7e |ne FIELD|-PAIRS ~|
|00004440| 0d 0a 20 20 20 20 20 25 | 46 6f 72 45 61 63 68 41 |.. %|ForEachA|
|00004450| 74 74 28 2c 29 7b 7e 7b | 26 46 50 31 7d 25 41 74 |tt(,){~{|&FP1}%At|
|00004460| 74 46 69 65 6c 64 4e 61 | 6d 65 20 20 20 20 20 20 |tFieldNa|me |
|00004470| 7e 7b 26 46 50 32 7d 25 | 41 74 74 46 69 65 6c 64 |~{&FP2}%|AttField|
|00004480| 4e 61 6d 65 20 20 20 20 | 20 20 7e 7b 26 46 50 33 |Name | ~{&FP3|
|00004490| 7d 7e 0d 0a 20 20 20 20 | 20 7d 0d 0a 26 53 63 6f |}~.. | }..&Sco|
|000044a0| 70 65 64 2d 44 65 66 69 | 6e 65 20 45 4e 41 42 4c |ped-Defi|ne ENABL|
|000044b0| 45 44 2d 54 41 42 4c 45 | 53 20 25 54 61 62 6c 65 |ED-TABLE|S %Table|
|000044c0| 4e 61 6d 65 0d 0a 26 53 | 63 6f 70 65 64 2d 44 65 |Name..&S|coped-De|
|000044d0| 66 69 6e 65 20 44 49 53 | 50 4c 41 59 45 44 2d 46 |fine DIS|PLAYED-F|
|000044e0| 49 45 4c 44 53 20 25 46 | 6f 72 45 61 63 68 41 74 |IELDS %F|orEachAt|
|000044f0| 74 28 2c 29 7b 25 54 61 | 62 6c 65 4e 61 6d 65 2e |t(,){%Ta|bleName.|
|00004500| 25 41 74 74 46 69 65 6c | 64 4e 61 6d 65 20 7d 20 |%AttFiel|dName } |
|00004510| 0d 0a 0d 0a 2f 2a 20 43 | 75 73 74 6f 6d 20 4c 69 |..../* C|ustom Li|
|00004520| 73 74 20 44 65 66 69 6e | 69 74 69 6f 6e 73 20 20 |st Defin|itions |
|00004530| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004540| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004550| 20 20 20 20 20 20 20 20 | 20 20 20 20 2a 2f 0d 0a | | */..|
|00004560| 2f 2a 20 41 44 4d 2d 43 | 52 45 41 54 45 2d 46 49 |/* ADM-C|REATE-FI|
|00004570| 45 4c 44 53 2c 41 44 4d | 2d 41 53 53 49 47 4e 2d |ELDS,ADM|-ASSIGN-|
|00004580| 46 49 45 4c 44 53 2c 4c | 69 73 74 2d 33 2c 4c 69 |FIELDS,L|ist-3,Li|
|00004590| 73 74 2d 34 2c 4c 69 73 | 74 2d 35 2c 4c 69 73 74 |st-4,Lis|t-5,List|
|000045a0| 2d 36 20 20 20 20 20 20 | 2a 2f 0d 0a 0d 0a 2f 2a |-6 |*/..../*|
|000045b0| 20 5f 55 49 42 2d 50 52 | 45 50 52 4f 43 45 53 53 | _UIB-PR|EPROCESS|
|000045c0| 4f 52 2d 42 4c 4f 43 4b | 2d 45 4e 44 20 2a 2f 0d |OR-BLOCK|-END */.|
|000045d0| 0a 26 41 4e 41 4c 59 5a | 45 2d 52 45 53 55 4d 45 |.&ANALYZ|E-RESUME|
|000045e0| 0d 0a 0d 0a 0d 0a 0d 0a | 2f 2a 20 2a 2a 2a 2a 2a |........|/* *****|
|000045f0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004600| 2a 2a 20 20 43 6f 6e 74 | 72 6f 6c 20 44 65 66 69 |** Cont|rol Defi|
|00004610| 6e 69 74 69 6f 6e 73 20 | 20 2a 2a 2a 2a 2a 2a 2a |nitions | *******|
|00004620| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 20 |********|******* |
|00004630| 2a 2f 0d 0a 0d 0a 0d 0a | 2f 2a 20 44 65 66 69 6e |*/......|/* Defin|
|00004640| 69 74 69 6f 6e 73 20 6f | 66 20 74 68 65 20 66 69 |itions o|f the fi|
|00004650| 65 6c 64 20 6c 65 76 65 | 6c 20 77 69 64 67 65 74 |eld leve|l widget|
|00004660| 73 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |s | |
|00004670| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004680| 2a 2f 0d 0a 0d 0a 2f 2a | 20 2a 2a 2a 2a 2a 2a 2a |*/..../*| *******|
|00004690| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000046a0| 2a 20 20 46 72 61 6d 65 | 20 44 65 66 69 6e 69 74 |* Frame| Definit|
|000046b0| 69 6f 6e 73 20 20 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |ions **|********|
|000046c0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 20 2a 2f |********|***** */|
|000046d0| 0d 0a 0d 0a 44 45 46 49 | 4e 45 20 46 52 41 4d 45 |....DEFI|NE FRAME|
|000046e0| 20 46 2d 4d 61 69 6e 0d | 0a 20 20 20 20 20 25 46 | F-Main.|. %F|
|000046f0| 6f 72 45 61 63 68 41 74 | 74 28 2c 29 7b 0d 0a 20 |orEachAt|t(,){.. |
|00004700| 20 20 20 20 20 20 20 20 | 20 20 25 3d 28 69 2c 25 | | %=(i,%|
|00004710| 2b 28 25 3a 69 2c 31 29 | 29 20 25 54 61 62 6c 65 |+(%:i,1)|) %Table|
|00004720| 4e 61 6d 65 2e 25 41 74 | 74 46 69 65 6c 64 4e 61 |Name.%At|tFieldNa|
|00004730| 6d 65 20 41 54 20 52 4f | 57 20 25 3a 69 20 43 4f |me AT RO|W %:i CO|
|00004740| 4c 20 32 30 20 43 4f 4c | 4f 4e 2d 41 4c 49 47 4e |L 20 COL|ON-ALIGN|
|00004750| 45 44 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 56 |ED.. | V|
|00004760| 49 45 57 2d 41 53 20 46 | 49 4c 4c 2d 49 4e 20 0d |IEW-AS F|ILL-IN .|
|00004770| 0a 20 20 20 20 20 20 20 | 20 20 20 53 49 5a 45 20 |. | SIZE |
|00004780| 33 30 20 42 59 20 31 0d | 0a 20 20 20 20 20 7d 20 |30 BY 1.|. } |
|00004790| 57 49 54 48 20 31 20 44 | 4f 57 4e 20 4e 4f 2d 42 |WITH 1 D|OWN NO-B|
|000047a0| 4f 58 20 4b 45 45 50 2d | 54 41 42 2d 4f 52 44 45 |OX KEEP-|TAB-ORDE|
|000047b0| 52 20 4f 56 45 52 4c 41 | 59 20 0d 0a 20 20 20 20 |R OVERLA|Y .. |
|000047c0| 20 20 20 20 20 53 49 44 | 45 2d 4c 41 42 45 4c 53 | SID|E-LABELS|
|000047d0| 20 4e 4f 2d 55 4e 44 45 | 52 4c 49 4e 45 20 54 48 | NO-UNDE|RLINE TH|
|000047e0| 52 45 45 2d 44 20 0d 0a | 20 20 20 20 20 20 20 20 |REE-D ..| |
|000047f0| 20 41 54 20 43 4f 4c 20 | 31 20 52 4f 57 20 31 20 | AT COL |1 ROW 1 |
|00004800| 53 43 52 4f 4c 4c 41 42 | 4c 45 20 2e 0d 0a 0d 0a |SCROLLAB|LE .....|
|00004810| 20 0d 0a 0d 0a 2f 2a 20 | 2a 2a 2a 2a 2a 2a 2a 2a | ..../* |********|
|00004820| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 20 |********|******* |
|00004830| 50 72 6f 63 65 64 75 72 | 65 20 53 65 74 74 69 6e |Procedur|e Settin|
|00004840| 67 73 20 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |gs *****|********|
|00004850| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 20 2a 2f 0d 0a |********|*** */..|
|00004860| 0d 0a 26 41 4e 41 4c 59 | 5a 45 2d 53 55 53 50 45 |..&ANALY|ZE-SUSPE|
|00004870| 4e 44 20 5f 50 52 4f 43 | 45 44 55 52 45 2d 53 45 |ND _PROC|EDURE-SE|
|00004880| 54 54 49 4e 47 53 0d 0a | 2f 2a 20 53 65 74 74 69 |TTINGS..|/* Setti|
|00004890| 6e 67 73 20 66 6f 72 20 | 54 48 49 53 2d 50 52 4f |ngs for |THIS-PRO|
|000048a0| 43 45 44 55 52 45 0d 0a | 20 20 20 54 79 70 65 3a |CEDURE..| Type:|
|000048b0| 20 53 6d 61 72 74 56 69 | 65 77 65 72 0d 0a 20 20 | SmartVi|ewer.. |
|000048c0| 20 45 78 74 65 72 6e 61 | 6c 20 54 61 62 6c 65 73 | Externa|l Tables|
|000048d0| 3a 20 25 3a 6d 79 64 62 | 2e 25 54 61 62 6c 65 4e |: %:mydb|.%TableN|
|000048e0| 61 6d 65 0d 0a 20 20 20 | 41 6c 6c 6f 77 3a 20 42 |ame.. |Allow: B|
|000048f0| 61 73 69 63 2c 44 42 2d | 46 69 65 6c 64 73 0d 0a |asic,DB-|Fields..|
|00004900| 20 20 20 46 72 61 6d 65 | 73 3a 20 31 0d 0a 20 20 | Frame|s: 1.. |
|00004910| 20 41 64 64 20 46 69 65 | 6c 64 73 20 74 6f 3a 20 | Add Fie|lds to: |
|00004920| 45 58 54 45 52 4e 41 4c | 2d 54 41 42 4c 45 53 0d |EXTERNAL|-TABLES.|
|00004930| 0a 20 20 20 4f 74 68 65 | 72 20 53 65 74 74 69 6e |. Othe|r Settin|
|00004940| 67 73 3a 20 50 45 52 53 | 49 53 54 45 4e 54 2d 4f |gs: PERS|ISTENT-O|
|00004950| 4e 4c 59 20 43 4f 4d 50 | 49 4c 45 0d 0a 20 2a 2f |NLY COMP|ILE.. */|
|00004960| 0d 0a 0d 0a 2f 2a 20 54 | 68 69 73 20 70 72 6f 63 |..../* T|his proc|
|00004970| 65 64 75 72 65 20 73 68 | 6f 75 6c 64 20 61 6c 77 |edure sh|ould alw|
|00004980| 61 79 73 20 62 65 20 52 | 55 4e 20 50 45 52 53 49 |ays be R|UN PERSI|
|00004990| 53 54 45 4e 54 2e 20 20 | 52 65 70 6f 72 74 20 74 |STENT. |Report t|
|000049a0| 68 65 20 65 72 72 6f 72 | 2c 20 20 2a 2f 0d 0a 2f |he error|, */../|
|000049b0| 2a 20 74 68 65 6e 20 63 | 6c 65 61 6e 75 70 20 61 |* then c|leanup a|
|000049c0| 6e 64 20 72 65 74 75 72 | 6e 2e 20 20 20 20 20 20 |nd retur|n. |
|000049d0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000049e0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000049f0| 20 20 20 20 20 20 2a 2f | 0d 0a 49 46 20 4e 4f 54 | */|..IF NOT|
|00004a00| 20 54 48 49 53 2d 50 52 | 4f 43 45 44 55 52 45 3a | THIS-PR|OCEDURE:|
|00004a10| 50 45 52 53 49 53 54 45 | 4e 54 20 54 48 45 4e 20 |PERSISTE|NT THEN |
|00004a20| 44 4f 3a 0d 0a 20 20 4d | 45 53 53 41 47 45 20 22 |DO:.. M|ESSAGE "|
|00004a30| 7b 26 46 49 4c 45 2d 4e | 41 4d 45 7d 20 73 68 6f |{&FILE-N|AME} sho|
|00004a40| 75 6c 64 20 6f 6e 6c 79 | 20 62 65 20 52 55 4e 20 |uld only| be RUN |
|00004a50| 50 45 52 53 49 53 54 45 | 4e 54 2e 22 0d 0a 20 20 |PERSISTE|NT.".. |
|00004a60| 20 20 20 20 20 20 20 20 | 56 49 45 57 2d 41 53 20 | |VIEW-AS |
|00004a70| 41 4c 45 52 54 2d 42 4f | 58 20 45 52 52 4f 52 20 |ALERT-BO|X ERROR |
|00004a80| 42 55 54 54 4f 4e 53 20 | 4f 4b 2e 0d 0a 20 20 52 |BUTTONS |OK... R|
|00004a90| 45 54 55 52 4e 2e 0d 0a | 45 4e 44 2e 0d 0a 0d 0a |ETURN...|END.....|
|00004aa0| 26 41 4e 41 4c 59 5a 45 | 2d 52 45 53 55 4d 45 20 |&ANALYZE|-RESUME |
|00004ab0| 5f 45 4e 44 2d 50 52 4f | 43 45 44 55 52 45 2d 53 |_END-PRO|CEDURE-S|
|00004ac0| 45 54 54 49 4e 47 53 0d | 0a 0d 0a 2f 2a 20 2a 2a |ETTINGS.|.../* **|
|00004ad0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004ae0| 2a 2a 2a 2a 2a 2a 2a 20 | 20 43 72 65 61 74 65 20 |******* | Create |
|00004af0| 57 69 6e 64 6f 77 20 20 | 2a 2a 2a 2a 2a 2a 2a 2a |Window |********|
|00004b00| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004b10| 2a 2a 20 2a 2f 0d 0a 0d | 0a 26 41 4e 41 4c 59 5a |** */...|.&ANALYZ|
|00004b20| 45 2d 53 55 53 50 45 4e | 44 20 5f 43 52 45 41 54 |E-SUSPEN|D _CREAT|
|00004b30| 45 2d 57 49 4e 44 4f 57 | 0d 0a 2f 2a 20 44 45 53 |E-WINDOW|../* DES|
|00004b40| 49 47 4e 20 57 69 6e 64 | 6f 77 20 64 65 66 69 6e |IGN Wind|ow defin|
|00004b50| 69 74 69 6f 6e 20 28 75 | 73 65 64 20 62 79 20 74 |ition (u|sed by t|
|00004b60| 68 65 20 55 49 42 29 20 | 0d 0a 20 20 43 52 45 41 |he UIB) |.. CREA|
|00004b70| 54 45 20 57 49 4e 44 4f | 57 20 56 2d 74 61 62 6c |TE WINDO|W V-tabl|
|00004b80| 65 2d 57 69 6e 20 41 53 | 53 49 47 4e 0d 0a 20 20 |e-Win AS|SIGN.. |
|00004b90| 20 20 20 20 20 20 20 48 | 45 49 47 48 54 20 20 20 | H|EIGHT |
|00004ba0| 20 20 20 20 20 20 20 20 | 20 20 3d 20 36 2e 38 38 | | = 6.88|
|00004bb0| 0d 0a 20 20 20 20 20 20 | 20 20 20 57 49 44 54 48 |.. | WIDTH|
|00004bc0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 3d 20 | | = |
|00004bd0| 36 36 2e 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |66... | |
|00004be0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004bf0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004c00| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004c10| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 2a 2f 0d | | */.|
|00004c20| 0a 26 41 4e 41 4c 59 5a | 45 2d 52 45 53 55 4d 45 |.&ANALYZ|E-RESUME|
|00004c30| 0d 0a 0d 0a 0d 0a 2f 2a | 20 2a 2a 2a 2a 2a 2a 2a |....../*| *******|
|00004c40| 2a 2a 2a 2a 2a 2a 2a 2a | 20 20 52 75 6e 74 69 6d |********| Runtim|
|00004c50| 65 20 41 74 74 72 69 62 | 75 74 65 73 20 61 6e 64 |e Attrib|utes and|
|00004c60| 20 55 49 42 20 53 65 74 | 74 69 6e 67 73 20 20 2a | UIB Set|tings *|
|00004c70| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 20 2a 2f |********|***** */|
|00004c80| 0d 0a 0d 0a 26 41 4e 41 | 4c 59 5a 45 2d 53 55 53 |....&ANA|LYZE-SUS|
|00004c90| 50 45 4e 44 20 5f 52 55 | 4e 2d 54 49 4d 45 2d 41 |PEND _RU|N-TIME-A|
|00004ca0| 54 54 52 49 42 55 54 45 | 53 0d 0a 2f 2a 20 53 45 |TTRIBUTE|S../* SE|
|00004cb0| 54 54 49 4e 47 53 20 46 | 4f 52 20 57 49 4e 44 4f |TTINGS F|OR WINDO|
|00004cc0| 57 20 56 2d 74 61 62 6c | 65 2d 57 69 6e 0d 0a 20 |W V-tabl|e-Win.. |
|00004cd0| 20 56 49 53 49 42 4c 45 | 2c 2c 52 55 4e 2d 50 45 | VISIBLE|,,RUN-PE|
|00004ce0| 52 53 49 53 54 45 4e 54 | 20 20 20 20 20 20 20 20 |RSISTENT| |
|00004cf0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004d00| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004d10| 20 20 20 20 20 20 20 2a | 2f 0d 0a 2f 2a 20 53 45 | *|/../* SE|
|00004d20| 54 54 49 4e 47 53 20 46 | 4f 52 20 46 52 41 4d 45 |TTINGS F|OR FRAME|
|00004d30| 20 46 2d 4d 61 69 6e 0d | 0a 20 20 20 4e 4f 54 2d | F-Main.|. NOT-|
|00004d40| 56 49 53 49 42 4c 45 20 | 53 69 7a 65 2d 74 6f 2d |VISIBLE |Size-to-|
|00004d50| 46 69 74 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |Fit | |
|00004d60| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004d70| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004d80| 20 2a 2f 0d 0a 41 53 53 | 49 47 4e 20 0d 0a 20 20 | */..ASS|IGN .. |
|00004d90| 20 20 20 20 20 46 52 41 | 4d 45 20 46 2d 4d 61 69 | FRA|ME F-Mai|
|00004da0| 6e 3a 53 43 52 4f 4c 4c | 41 42 4c 45 20 20 20 20 |n:SCROLL|ABLE |
|00004db0| 20 20 20 3d 20 46 41 4c | 53 45 0d 0a 20 20 20 20 | = FAL|SE.. |
|00004dc0| 20 20 20 46 52 41 4d 45 | 20 46 2d 4d 61 69 6e 3a | FRAME| F-Main:|
|00004dd0| 48 49 44 44 45 4e 20 20 | 20 20 20 20 20 20 20 20 |HIDDEN | |
|00004de0| 20 3d 20 54 52 55 45 2e | 0d 0a 0d 0a 2f 2a 20 5f | = TRUE.|..../* _|
|00004df0| 52 55 4e 2d 54 49 4d 45 | 2d 41 54 54 52 49 42 55 |RUN-TIME|-ATTRIBU|
|00004e00| 54 45 53 2d 45 4e 44 20 | 2a 2f 0d 0a 26 41 4e 41 |TES-END |*/..&ANA|
|00004e10| 4c 59 5a 45 2d 52 45 53 | 55 4d 45 0d 0a 0d 0a 0d |LYZE-RES|UME.....|
|00004e20| 0a 2f 2a 20 53 65 74 74 | 69 6e 67 20 69 6e 66 6f |./* Sett|ing info|
|00004e30| 72 6d 61 74 69 6f 6e 20 | 66 6f 72 20 51 75 65 72 |rmation |for Quer|
|00004e40| 69 65 73 20 61 6e 64 20 | 42 72 6f 77 73 65 20 57 |ies and |Browse W|
|00004e50| 69 64 67 65 74 73 20 66 | 69 65 6c 64 73 20 20 20 |idgets f|ields |
|00004e60| 20 20 20 20 20 20 20 20 | 20 2a 2f 0d 0a 0d 0a 26 | | */....&|
|00004e70| 41 4e 41 4c 59 5a 45 2d | 53 55 53 50 45 4e 44 20 |ANALYZE-|SUSPEND |
|00004e80| 5f 51 55 45 52 59 2d 42 | 4c 4f 43 4b 20 46 52 41 |_QUERY-B|LOCK FRA|
|00004e90| 4d 45 20 46 2d 4d 61 69 | 6e 0d 0a 2f 2a 20 51 75 |ME F-Mai|n../* Qu|
|00004ea0| 65 72 79 20 72 65 62 75 | 69 6c 64 20 69 6e 66 6f |ery rebu|ild info|
|00004eb0| 72 6d 61 74 69 6f 6e 20 | 66 6f 72 20 46 52 41 4d |rmation |for FRAM|
|00004ec0| 45 20 46 2d 4d 61 69 6e | 0d 0a 20 20 20 20 20 5f |E F-Main|.. _|
|00004ed0| 4f 70 74 69 6f 6e 73 20 | 20 20 20 20 20 20 20 20 |Options | |
|00004ee0| 20 3d 20 22 4e 4f 2d 4c | 4f 43 4b 22 0d 0a 20 20 | = "NO-L|OCK".. |
|00004ef0| 20 20 20 5f 51 75 65 72 | 79 20 20 20 20 20 20 20 | _Quer|y |
|00004f00| 20 20 20 20 20 69 73 20 | 4e 4f 54 20 4f 50 45 4e | is |NOT OPEN|
|00004f10| 45 44 0d 0a 2a 2f 20 20 | 2f 2a 20 46 52 41 4d 45 |ED..*/ |/* FRAME|
|00004f20| 20 46 2d 4d 61 69 6e 20 | 2a 2f 0d 0a 26 41 4e 41 | F-Main |*/..&ANA|
|00004f30| 4c 59 5a 45 2d 52 45 53 | 55 4d 45 0d 0a 0d 0a 20 |LYZE-RES|UME.... |
|00004f40| 0d 0a 0d 0a 0d 0a 26 41 | 4e 41 4c 59 5a 45 2d 53 |......&A|NALYZE-S|
|00004f50| 55 53 50 45 4e 44 20 5f | 55 49 42 2d 43 4f 44 45 |USPEND _|UIB-CODE|
|00004f60| 2d 42 4c 4f 43 4b 20 5f | 43 55 53 54 4f 4d 20 5f |-BLOCK _|CUSTOM _|
|00004f70| 49 4e 43 4c 55 44 45 44 | 2d 4c 49 42 20 56 2d 74 |INCLUDED|-LIB V-t|
|00004f80| 61 62 6c 65 2d 57 69 6e | 20 0d 0a 2f 2a 20 2a 2a |able-Win| ../* **|
|00004f90| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004fa0| 2a 2a 2a 2a 2a 2a 2a 20 | 49 6e 63 6c 75 64 65 64 |******* |Included|
|00004fb0| 2d 4c 69 62 72 61 72 69 | 65 73 20 2a 2a 2a 2a 2a |-Librari|es *****|
|00004fc0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004fd0| 2a 2a 20 2a 2f 0d 0a 0d | 0a 7b 73 72 63 2f 61 64 |** */...|.{src/ad|
|00004fe0| 6d 2f 6d 65 74 68 6f 64 | 2f 76 69 65 77 65 72 2e |m/method|/viewer.|
|00004ff0| 69 7d 0d 0a 0d 0a 2f 2a | 20 5f 55 49 42 2d 43 4f |i}..../*| _UIB-CO|
|00005000| 44 45 2d 42 4c 4f 43 4b | 2d 45 4e 44 20 2a 2f 0d |DE-BLOCK|-END */.|
|00005010| 0a 26 41 4e 41 4c 59 5a | 45 2d 52 45 53 55 4d 45 |.&ANALYZ|E-RESUME|
|00005020| 0d 0a 0d 0a 0d 0a 0d 0a | 26 41 4e 41 4c 59 5a 45 |........|&ANALYZE|
|00005030| 2d 53 55 53 50 45 4e 44 | 20 5f 55 49 42 2d 43 4f |-SUSPEND| _UIB-CO|
|00005040| 44 45 2d 42 4c 4f 43 4b | 20 5f 43 55 53 54 4f 4d |DE-BLOCK| _CUSTOM|
|00005050| 20 5f 4d 41 49 4e 2d 42 | 4c 4f 43 4b 20 56 2d 74 | _MAIN-B|LOCK V-t|
|00005060| 61 62 6c 65 2d 57 69 6e | 20 0d 0a 0d 0a 0d 0a 2f |able-Win| ....../|
|00005070| 2a 20 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |* ******|********|
|00005080| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 20 20 4d |********|***** M|
|00005090| 61 69 6e 20 42 6c 6f 63 | 6b 20 20 2a 2a 2a 2a 2a |ain Bloc|k *****|
|000050a0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000050b0| 2a 2a 2a 2a 2a 2a 20 2a | 2f 0d 0a 0d 0a 20 20 26 |****** *|/.... &|
|000050c0| 49 46 20 44 45 46 49 4e | 45 44 28 55 49 42 5f 49 |IF DEFIN|ED(UIB_I|
|000050d0| 53 5f 52 55 4e 4e 49 4e | 47 29 20 3c 3e 20 30 20 |S_RUNNIN|G) <> 0 |
|000050e0| 26 54 48 45 4e 20 20 20 | 20 20 20 20 20 20 20 0d |&THEN | .|
|000050f0| 0a 20 20 20 20 52 55 4e | 20 64 69 73 70 61 74 63 |. RUN| dispatc|
|00005100| 68 20 49 4e 20 54 48 49 | 53 2d 50 52 4f 43 45 44 |h IN THI|S-PROCED|
|00005110| 55 52 45 20 28 27 69 6e | 69 74 69 61 6c 69 7a 65 |URE ('in|itialize|
|00005120| 27 3a 55 29 2e 20 20 20 | 20 20 20 20 20 0d 0a 20 |':U). | .. |
|00005130| 20 26 45 4e 44 49 46 20 | 20 20 20 20 20 20 20 20 | &ENDIF | |
|00005140| 0d 0a 20 20 0d 0a 20 20 | 2f 2a 2a 2a 2a 2a 2a 2a |.. .. |/*******|
|00005150| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00005160| 2a 20 49 4e 54 45 52 4e | 41 4c 20 50 52 4f 43 45 |* INTERN|AL PROCE|
|00005170| 44 55 52 45 53 20 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |DURES **|********|
|00005180| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2f 0d 0a 0d 0a 2f |********|**/..../|
|00005190| 2a 20 5f 55 49 42 2d 43 | 4f 44 45 2d 42 4c 4f 43 |* _UIB-C|ODE-BLOC|
|000051a0| 4b 2d 45 4e 44 20 2a 2f | 0d 0a 26 41 4e 41 4c 59 |K-END */|..&ANALY|
|000051b0| 5a 45 2d 52 45 53 55 4d | 45 0d 0a 0d 0a 0d 0a 2f |ZE-RESUM|E....../|
|000051c0| 2a 20 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |* ******|********|
|000051d0| 2a 2a 2a 2a 2a 2a 2a 2a | 20 20 49 6e 74 65 72 6e |********| Intern|
|000051e0| 61 6c 20 50 72 6f 63 65 | 64 75 72 65 73 20 20 2a |al Proce|dures *|
|000051f0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00005200| 2a 2a 2a 2a 2a 2a 20 2a | 2f 0d 0a 0d 0a 26 41 4e |****** *|/....&AN|
|00005210| 41 4c 59 5a 45 2d 53 55 | 53 50 45 4e 44 20 5f 55 |ALYZE-SU|SPEND _U|
|00005220| 49 42 2d 43 4f 44 45 2d | 42 4c 4f 43 4b 20 5f 50 |IB-CODE-|BLOCK _P|
|00005230| 52 4f 43 45 44 55 52 45 | 20 61 64 6d 2d 72 6f 77 |ROCEDURE| adm-row|
|00005240| 2d 61 76 61 69 6c 61 62 | 6c 65 20 56 2d 74 61 62 |-availab|le V-tab|
|00005250| 6c 65 2d 57 69 6e 20 5f | 41 44 4d 2d 52 4f 57 2d |le-Win _|ADM-ROW-|
|00005260| 41 56 41 49 4c 41 42 4c | 45 0d 0a 50 52 4f 43 45 |AVAILABL|E..PROCE|
|00005270| 44 55 52 45 20 61 64 6d | 2d 72 6f 77 2d 61 76 61 |DURE adm|-row-ava|
|00005280| 69 6c 61 62 6c 65 20 3a | 0d 0a 2f 2a 2d 2d 2d 2d |ilable :|../*----|
|00005290| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|000052a0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|000052b0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|000052c0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|000052d0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 0d 0a 20 20 50 75 |--------|--.. Pu|
|000052e0| 72 70 6f 73 65 3a 20 20 | 20 20 20 44 69 73 70 61 |rpose: | Dispa|
|000052f0| 74 63 68 65 64 20 74 6f | 20 74 68 69 73 20 70 72 |tched to| this pr|
|00005300| 6f 63 65 64 75 72 65 20 | 77 68 65 6e 20 74 68 65 |ocedure |when the|
|00005310| 20 72 65 63 6f 72 64 2d | 0d 0a 20 20 20 20 20 20 | record-|.. |
|00005320| 20 20 20 20 20 20 20 20 | 20 73 6f 75 72 63 65 20 | | source |
|00005330| 68 61 73 20 61 20 6e 65 | 77 20 72 6f 77 20 61 76 |has a ne|w row av|
|00005340| 61 69 6c 61 62 6c 65 2e | 20 20 54 68 69 73 20 70 |ailable.| This p|
|00005350| 72 6f 63 65 64 75 72 65 | 0d 0a 20 20 20 20 20 20 |rocedure|.. |
|00005360| 20 20 20 20 20 20 20 20 | 20 74 72 69 65 73 20 74 | | tries t|
|00005370| 6f 20 67 65 74 20 74 68 | 65 20 6e 65 77 20 72 6f |o get th|e new ro|
|00005380| 77 20 61 6e 64 20 64 69 | 73 70 6c 61 79 20 69 74 |w and di|splay it|
|00005390| 2e 0d 0a 20 20 50 61 72 | 61 6d 65 74 65 72 73 3a |... Par|ameters:|
|000053a0| 20 20 3c 6e 6f 6e 65 3e | 0d 0a 2d 2d 2d 2d 2d 2d | <none>|..------|
|000053b0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|000053c0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|000053d0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|000053e0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|000053f0| 2d 2d 2d 2d 2d 2d 2d 2d | 2a 2f 0d 0a 0d 0a 20 20 |--------|*/.... |
|00005400| 2f 2a 20 44 65 66 69 6e | 65 20 76 61 72 69 61 62 |/* Defin|e variab|
|00005410| 6c 65 73 20 6e 65 65 64 | 65 64 20 62 79 20 74 68 |les need|ed by th|
|00005420| 69 73 20 69 6e 74 65 72 | 6e 61 6c 20 70 72 6f 63 |is inter|nal proc|
|00005430| 65 64 75 72 65 2e 20 20 | 20 20 20 20 20 20 20 20 |edure. | |
|00005440| 20 20 20 2a 2f 0d 0a 20 | 20 7b 73 72 63 2f 61 64 | */.. | {src/ad|
|00005450| 6d 2f 74 65 6d 70 6c 61 | 74 65 2f 72 6f 77 2d 68 |m/templa|te/row-h|
|00005460| 65 61 64 2e 69 7d 0d 0a | 0d 0a 20 20 2f 2a 20 43 |ead.i}..|.. /* C|
|00005470| 72 65 61 74 65 20 61 20 | 6c 69 73 74 20 6f 66 20 |reate a |list of |
|00005480| 61 6c 6c 20 74 68 65 20 | 74 61 62 6c 65 73 20 74 |all the |tables t|
|00005490| 68 61 74 20 77 65 20 6e | 65 65 64 20 74 6f 20 67 |hat we n|eed to g|
|000054a0| 65 74 2e 20 20 20 20 20 | 20 20 20 20 20 20 20 2a |et. | *|
|000054b0| 2f 0d 0a 20 20 7b 73 72 | 63 2f 61 64 6d 2f 74 65 |/.. {sr|c/adm/te|
|000054c0| 6d 70 6c 61 74 65 2f 72 | 6f 77 2d 6c 69 73 74 2e |mplate/r|ow-list.|
|000054d0| 69 20 22 25 54 61 62 6c | 65 4e 61 6d 65 22 7d 0d |i "%Tabl|eName"}.|
|000054e0| 0a 0d 0a 20 20 2f 2a 20 | 47 65 74 20 74 68 65 20 |... /* |Get the |
|000054f0| 72 65 63 6f 72 64 20 52 | 4f 57 49 44 27 73 20 66 |record R|OWID's f|
|00005500| 72 6f 6d 20 74 68 65 20 | 52 45 43 4f 52 44 2d 53 |rom the |RECORD-S|
|00005510| 4f 55 52 43 45 2e 20 20 | 20 20 20 20 20 20 20 20 |OURCE. | |
|00005520| 20 20 20 20 20 20 20 20 | 2a 2f 0d 0a 20 20 7b 73 | |*/.. {s|
|00005530| 72 63 2f 61 64 6d 2f 74 | 65 6d 70 6c 61 74 65 2f |rc/adm/t|emplate/|
|00005540| 72 6f 77 2d 67 65 74 2e | 69 7d 0d 0a 0d 0a 20 20 |row-get.|i}.... |
|00005550| 2f 2a 20 46 49 4e 44 20 | 65 61 63 68 20 72 65 63 |/* FIND |each rec|
|00005560| 6f 72 64 20 73 70 65 63 | 69 66 69 65 64 20 62 79 |ord spec|ified by|
|00005570| 20 74 68 65 20 52 45 43 | 4f 52 44 2d 53 4f 55 52 | the REC|ORD-SOUR|
|00005580| 43 45 2e 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |CE. | |
|00005590| 20 20 20 2a 2f 0d 0a 20 | 20 7b 73 72 63 2f 61 64 | */.. | {src/ad|
|000055a0| 6d 2f 74 65 6d 70 6c 61 | 74 65 2f 72 6f 77 2d 66 |m/templa|te/row-f|
|000055b0| 69 6e 64 2e 69 20 22 25 | 54 61 62 6c 65 4e 61 6d |ind.i "%|TableNam|
|000055c0| 65 22 7d 0d 0a 0d 0a 20 | 20 2f 2a 20 50 72 6f 63 |e"}.... | /* Proc|
|000055d0| 65 73 73 20 74 68 65 20 | 6e 65 77 6c 79 20 61 76 |ess the |newly av|
|000055e0| 61 69 6c 61 62 6c 65 20 | 72 65 63 6f 72 64 73 20 |ailable |records |
|000055f0| 28 69 2e 65 2e 20 64 69 | 73 70 6c 61 79 20 66 69 |(i.e. di|splay fi|
|00005600| 65 6c 64 73 2c 0d 0a 20 | 20 20 20 20 6f 70 65 6e |elds,.. | open|
|00005610| 20 71 75 65 72 69 65 73 | 2c 20 61 6e 64 2f 6f 72 | queries|, and/or|
|00005620| 20 70 61 73 73 20 72 65 | 63 6f 72 64 73 20 6f 6e | pass re|cords on|
|00005630| 20 74 6f 20 61 6e 79 20 | 52 45 43 4f 52 44 2d 54 | to any |RECORD-T|
|00005640| 41 52 47 45 54 53 29 2e | 20 20 20 20 2a 2f 0d 0a |ARGETS).| */..|
|00005650| 20 20 7b 73 72 63 2f 61 | 64 6d 2f 74 65 6d 70 6c | {src/a|dm/templ|
|00005660| 61 74 65 2f 72 6f 77 2d | 65 6e 64 2e 69 7d 0d 0a |ate/row-|end.i}..|
|00005670| 0d 0a 45 4e 44 20 50 52 | 4f 43 45 44 55 52 45 2e |..END PR|OCEDURE.|
|00005680| 0d 0a 0d 0a 2f 2a 20 5f | 55 49 42 2d 43 4f 44 45 |..../* _|UIB-CODE|
|00005690| 2d 42 4c 4f 43 4b 2d 45 | 4e 44 20 2a 2f 0d 0a 26 |-BLOCK-E|ND */..&|
|000056a0| 41 4e 41 4c 59 5a 45 2d | 52 45 53 55 4d 45 0d 0a |ANALYZE-|RESUME..|
|000056b0| 0d 0a 0d 0a 26 41 4e 41 | 4c 59 5a 45 2d 53 55 53 |....&ANA|LYZE-SUS|
|000056c0| 50 45 4e 44 20 5f 55 49 | 42 2d 43 4f 44 45 2d 42 |PEND _UI|B-CODE-B|
|000056d0| 4c 4f 43 4b 20 5f 50 52 | 4f 43 45 44 55 52 45 20 |LOCK _PR|OCEDURE |
|000056e0| 64 69 73 61 62 6c 65 5f | 55 49 20 56 2d 74 61 62 |disable_|UI V-tab|
|000056f0| 6c 65 2d 57 69 6e 20 5f | 44 45 46 41 55 4c 54 2d |le-Win _|DEFAULT-|
|00005700| 44 49 53 41 42 4c 45 0d | 0a 50 52 4f 43 45 44 55 |DISABLE.|.PROCEDU|
|00005710| 52 45 20 64 69 73 61 62 | 6c 65 5f 55 49 20 3a 0d |RE disab|le_UI :.|
|00005720| 0a 2f 2a 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |./*-----|--------|
|00005730| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00005740| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00005750| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00005760| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00005770| 2d 0d 0a 20 20 50 75 72 | 70 6f 73 65 3a 20 20 20 |-.. Pur|pose: |
|00005780| 20 20 44 49 53 41 42 4c | 45 20 74 68 65 20 55 73 | DISABL|E the Us|
|00005790| 65 72 20 49 6e 74 65 72 | 66 61 63 65 0d 0a 20 20 |er Inter|face.. |
|000057a0| 50 61 72 61 6d 65 74 65 | 72 73 3a 20 20 3c 6e 6f |Paramete|rs: <no|
|000057b0| 6e 65 3e 0d 0a 20 20 4e | 6f 74 65 73 3a 20 20 20 |ne>.. N|otes: |
|000057c0| 20 20 20 20 48 65 72 65 | 20 77 65 20 63 6c 65 61 | Here| we clea|
|000057d0| 6e 2d 75 70 20 74 68 65 | 20 75 73 65 72 2d 69 6e |n-up the| user-in|
|000057e0| 74 65 72 66 61 63 65 20 | 62 79 20 64 65 6c 65 74 |terface |by delet|
|000057f0| 69 6e 67 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |ing.. | |
|00005800| 20 20 20 20 64 79 6e 61 | 6d 69 63 20 77 69 64 67 | dyna|mic widg|
|00005810| 65 74 73 20 77 65 20 68 | 61 76 65 20 63 72 65 61 |ets we h|ave crea|
|00005820| 74 65 64 20 61 6e 64 2f | 6f 72 20 68 69 64 65 20 |ted and/|or hide |
|00005830| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.. | |
|00005840| 20 66 72 61 6d 65 73 2e | 20 20 54 68 69 73 20 70 | frames.| This p|
|00005850| 72 6f 63 65 64 75 72 65 | 20 69 73 20 75 73 75 61 |rocedure| is usua|
|00005860| 6c 6c 79 20 63 61 6c 6c | 65 64 20 77 68 65 6e 0d |lly call|ed when.|
|00005870| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|00005880| 77 65 20 61 72 65 20 72 | 65 61 64 79 20 74 6f 20 |we are r|eady to |
|00005890| 22 63 6c 65 61 6e 2d 75 | 70 22 20 61 66 74 65 72 |"clean-u|p" after|
|000058a0| 20 72 75 6e 6e 69 6e 67 | 2e 0d 0a 2d 2d 2d 2d 2d | running|...-----|
|000058b0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|000058c0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|000058d0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|000058e0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|000058f0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2a 2f 0d 0a 20 20 2f |--------|-*/.. /|
|00005900| 2a 20 48 69 64 65 20 61 | 6c 6c 20 66 72 61 6d 65 |* Hide a|ll frame|
|00005910| 73 2e 20 2a 2f 0d 0a 20 | 20 48 49 44 45 20 46 52 |s. */.. | HIDE FR|
|00005920| 41 4d 45 20 46 2d 4d 61 | 69 6e 2e 0d 0a 20 20 49 |AME F-Ma|in... I|
|00005930| 46 20 54 48 49 53 2d 50 | 52 4f 43 45 44 55 52 45 |F THIS-P|ROCEDURE|
|00005940| 3a 50 45 52 53 49 53 54 | 45 4e 54 20 54 48 45 4e |:PERSIST|ENT THEN|
|00005950| 20 44 45 4c 45 54 45 20 | 50 52 4f 43 45 44 55 52 | DELETE |PROCEDUR|
|00005960| 45 20 54 48 49 53 2d 50 | 52 4f 43 45 44 55 52 45 |E THIS-P|ROCEDURE|
|00005970| 2e 0d 0a 45 4e 44 20 50 | 52 4f 43 45 44 55 52 45 |...END P|ROCEDURE|
|00005980| 2e 0d 0a 0d 0a 2f 2a 20 | 5f 55 49 42 2d 43 4f 44 |...../* |_UIB-COD|
|00005990| 45 2d 42 4c 4f 43 4b 2d | 45 4e 44 20 2a 2f 0d 0a |E-BLOCK-|END */..|
|000059a0| 26 41 4e 41 4c 59 5a 45 | 2d 52 45 53 55 4d 45 0d |&ANALYZE|-RESUME.|
|000059b0| 0a 0d 0a 0d 0a 26 41 4e | 41 4c 59 5a 45 2d 53 55 |.....&AN|ALYZE-SU|
|000059c0| 53 50 45 4e 44 20 5f 55 | 49 42 2d 43 4f 44 45 2d |SPEND _U|IB-CODE-|
|000059d0| 42 4c 4f 43 4b 20 5f 50 | 52 4f 43 45 44 55 52 45 |BLOCK _P|ROCEDURE|
|000059e0| 20 73 65 6e 64 2d 72 65 | 63 6f 72 64 73 20 56 2d | send-re|cords V-|
|000059f0| 74 61 62 6c 65 2d 57 69 | 6e 20 5f 41 44 4d 2d 53 |table-Wi|n _ADM-S|
|00005a00| 45 4e 44 2d 52 45 43 4f | 52 44 53 0d 0a 50 52 4f |END-RECO|RDS..PRO|
|00005a10| 43 45 44 55 52 45 20 73 | 65 6e 64 2d 72 65 63 6f |CEDURE s|end-reco|
|00005a20| 72 64 73 20 3a 0d 0a 2f | 2a 2d 2d 2d 2d 2d 2d 2d |rds :../|*-------|
|00005a30| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00005a40| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00005a50| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00005a60| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00005a70| 2d 2d 2d 2d 2d 2d 2d 0d | 0a 20 20 50 75 72 70 6f |-------.|. Purpo|
|00005a80| 73 65 3a 20 20 20 20 20 | 53 65 6e 64 20 72 65 63 |se: |Send rec|
|00005a90| 6f 72 64 20 52 4f 57 49 | 44 27 73 20 66 6f 72 20 |ord ROWI|D's for |
|00005aa0| 61 6c 6c 20 74 61 62 6c | 65 73 20 75 73 65 64 20 |all tabl|es used |
|00005ab0| 62 79 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |by.. | |
|00005ac0| 20 20 20 74 68 69 73 20 | 66 69 6c 65 2e 0d 0a 20 | this |file... |
|00005ad0| 20 50 61 72 61 6d 65 74 | 65 72 73 3a 20 20 73 65 | Paramet|ers: se|
|00005ae0| 65 20 74 65 6d 70 6c 61 | 74 65 2f 73 6e 64 2d 68 |e templa|te/snd-h|
|00005af0| 65 61 64 2e 69 0d 0a 2d | 2d 2d 2d 2d 2d 2d 2d 2d |ead.i..-|--------|
|00005b00| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00005b10| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00005b20| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00005b30| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00005b40| 2d 2d 2d 2d 2d 2a 2f 0d | 0a 0d 0a 20 20 2f 2a 20 |-----*/.|... /* |
|00005b50| 44 65 66 69 6e 65 20 76 | 61 72 69 61 62 6c 65 73 |Define v|ariables|
|00005b60| 20 6e 65 65 64 65 64 20 | 62 79 20 74 68 69 73 20 | needed |by this |
|00005b70| 69 6e 74 65 72 6e 61 6c | 20 70 72 6f 63 65 64 75 |internal| procedu|
|00005b80| 72 65 2e 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |re. | |
|00005b90| 20 20 2a 2f 0d 0a 20 20 | 7b 73 72 63 2f 61 64 6d | */.. |{src/adm|
|00005ba0| 2f 74 65 6d 70 6c 61 74 | 65 2f 73 6e 64 2d 68 65 |/templat|e/snd-he|
|00005bb0| 61 64 2e 69 7d 0d 0a 0d | 0a 20 20 2f 2a 20 46 6f |ad.i}...|. /* Fo|
|00005bc0| 72 20 65 61 63 68 20 72 | 65 71 75 65 73 74 65 64 |r each r|equested|
|00005bd0| 20 74 61 62 6c 65 2c 20 | 70 75 74 20 69 74 27 73 | table, |put it's|
|00005be0| 20 52 4f 57 49 44 20 69 | 6e 20 74 68 65 20 6f 75 | ROWID i|n the ou|
|00005bf0| 74 70 75 74 20 6c 69 73 | 74 2e 20 20 20 20 20 20 |tput lis|t. |
|00005c00| 2a 2f 0d 0a 20 20 7b 73 | 72 63 2f 61 64 6d 2f 74 |*/.. {s|rc/adm/t|
|00005c10| 65 6d 70 6c 61 74 65 2f | 73 6e 64 2d 6c 69 73 74 |emplate/|snd-list|
|00005c20| 2e 69 20 22 25 54 61 62 | 6c 65 4e 61 6d 65 22 7d |.i "%Tab|leName"}|
|00005c30| 0d 0a 0d 0a 20 20 2f 2a | 20 44 65 61 6c 20 77 69 |.... /*| Deal wi|
|00005c40| 74 68 20 61 6e 79 20 75 | 6e 65 78 70 65 63 74 65 |th any u|nexpecte|
|00005c50| 64 20 74 61 62 6c 65 20 | 72 65 71 75 65 73 74 73 |d table |requests|
|00005c60| 20 62 65 66 6f 72 65 20 | 63 6c 6f 73 69 6e 67 2e | before |closing.|
|00005c70| 20 20 20 20 20 20 20 20 | 20 20 20 2a 2f 0d 0a 20 | | */.. |
|00005c80| 20 7b 73 72 63 2f 61 64 | 6d 2f 74 65 6d 70 6c 61 | {src/ad|m/templa|
|00005c90| 74 65 2f 73 6e 64 2d 65 | 6e 64 2e 69 7d 0d 0a 0d |te/snd-e|nd.i}...|
|00005ca0| 0a 45 4e 44 20 50 52 4f | 43 45 44 55 52 45 2e 0d |.END PRO|CEDURE..|
|00005cb0| 0a 0d 0a 2f 2a 20 5f 55 | 49 42 2d 43 4f 44 45 2d |.../* _U|IB-CODE-|
|00005cc0| 42 4c 4f 43 4b 2d 45 4e | 44 20 2a 2f 0d 0a 26 41 |BLOCK-EN|D */..&A|
|00005cd0| 4e 41 4c 59 5a 45 2d 52 | 45 53 55 4d 45 0d 0a 0d |NALYZE-R|ESUME...|
|00005ce0| 0a 0d 0a 26 41 4e 41 4c | 59 5a 45 2d 53 55 53 50 |...&ANAL|YZE-SUSP|
|00005cf0| 45 4e 44 20 5f 55 49 42 | 2d 43 4f 44 45 2d 42 4c |END _UIB|-CODE-BL|
|00005d00| 4f 43 4b 20 5f 50 52 4f | 43 45 44 55 52 45 20 73 |OCK _PRO|CEDURE s|
|00005d10| 74 61 74 65 2d 63 68 61 | 6e 67 65 64 20 56 2d 74 |tate-cha|nged V-t|
|00005d20| 61 62 6c 65 2d 57 69 6e | 20 0d 0a 50 52 4f 43 45 |able-Win| ..PROCE|
|00005d30| 44 55 52 45 20 73 74 61 | 74 65 2d 63 68 61 6e 67 |DURE sta|te-chang|
|00005d40| 65 64 20 3a 0d 0a 2f 2a | 20 2d 2d 2d 2d 2d 2d 2d |ed :../*| -------|
|00005d50| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00005d60| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00005d70| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00005d80| 2d 2d 2d 2d 0d 0a 20 20 | 50 75 72 70 6f 73 65 3a |----.. |Purpose:|
|00005d90| 20 20 20 20 20 0d 0a 20 | 20 50 61 72 61 6d 65 74 | .. | Paramet|
|00005da0| 65 72 73 3a 20 20 3c 6e | 6f 6e 65 3e 0d 0a 20 20 |ers: <n|one>.. |
|00005db0| 4e 6f 74 65 73 3a 20 20 | 20 20 20 20 20 0d 0a 2d |Notes: | ..-|
|00005dc0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00005dd0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00005de0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00005df0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2a 2f 0d 0a |--------|----*/..|
|00005e00| 20 20 44 45 46 49 4e 45 | 20 49 4e 50 55 54 20 50 | DEFINE| INPUT P|
|00005e10| 41 52 41 4d 45 54 45 52 | 20 70 2d 69 73 73 75 65 |ARAMETER| p-issue|
|00005e20| 72 2d 68 64 6c 20 41 53 | 20 48 41 4e 44 4c 45 20 |r-hdl AS| HANDLE |
|00005e30| 20 20 20 4e 4f 2d 55 4e | 44 4f 2e 0d 0a 20 20 44 | NO-UN|DO... D|
|00005e40| 45 46 49 4e 45 20 49 4e | 50 55 54 20 50 41 52 41 |EFINE IN|PUT PARA|
|00005e50| 4d 45 54 45 52 20 70 2d | 73 74 61 74 65 20 20 20 |METER p-|state |
|00005e60| 20 20 20 41 53 20 43 48 | 41 52 41 43 54 45 52 20 | AS CH|ARACTER |
|00005e70| 4e 4f 2d 55 4e 44 4f 2e | 0d 0a 0d 0a 20 20 43 41 |NO-UNDO.|.... CA|
|00005e80| 53 45 20 70 2d 73 74 61 | 74 65 3a 0d 0a 20 20 20 |SE p-sta|te:.. |
|00005e90| 20 20 20 2f 2a 20 4f 62 | 6a 65 63 74 20 69 6e 73 | /* Ob|ject ins|
|00005ea0| 74 61 6e 63 65 20 43 41 | 53 45 73 20 63 61 6e 20 |tance CA|SEs can |
|00005eb0| 67 6f 20 68 65 72 65 20 | 74 6f 20 72 65 70 6c 61 |go here |to repla|
|00005ec0| 63 65 20 73 74 61 6e 64 | 61 72 64 20 62 65 68 61 |ce stand|ard beha|
|00005ed0| 76 69 6f 72 0d 0a 20 20 | 20 20 20 20 20 20 20 6f |vior.. | o|
|00005ee0| 72 20 61 64 64 20 6e 65 | 77 20 63 61 73 65 73 2e |r add ne|w cases.|
|00005ef0| 20 2a 2f 0d 0a 20 20 20 | 20 20 20 7b 73 72 63 2f | */.. | {src/|
|00005f00| 61 64 6d 2f 74 65 6d 70 | 6c 61 74 65 2f 76 73 74 |adm/temp|late/vst|
|00005f10| 61 74 65 73 2e 69 7d 0d | 0a 20 20 45 4e 44 20 43 |ates.i}.|. END C|
|00005f20| 41 53 45 2e 0d 0a 45 4e | 44 20 50 52 4f 43 45 44 |ASE...EN|D PROCED|
|00005f30| 55 52 45 2e 0d 0a 0d 0a | 2f 2a 20 5f 55 49 42 2d |URE.....|/* _UIB-|
|00005f40| 43 4f 44 45 2d 42 4c 4f | 43 4b 2d 45 4e 44 20 2a |CODE-BLO|CK-END *|
|00005f50| 2f 0d 0a 26 41 4e 41 4c | 59 5a 45 2d 52 45 53 55 |/..&ANAL|YZE-RESU|
|00005f60| 4d 45 0d 0a 7d 7d 0d 0a | 0d 0a 00 00 00 00 10 00 |ME..}}..|........|
|00005f70| 00 00 00 00 00 00 00 00 | 00 00 06 00 00 00 1a 00 |........|........|
|00005f80| 76 2d 70 61 72 65 6e 74 | 2d 63 68 69 6c 64 2d 61 |v-parent|-child-a|
|00005f90| 6c 6c 2d 63 6f 6c 75 6d | 6e 73 b6 25 25 44 65 63 |ll-colum|ns.%%Dec|
|00005fa0| 6c 28 6d 79 64 62 29 0d | 0a 25 3d 28 6d 79 64 62 |l(mydb).|.%=(mydb|
|00005fb0| 2c 44 42 5f 4e 41 4d 45 | 29 0d 0a 25 46 6f 72 45 |,DB_NAME|)..%ForE|
|00005fc0| 61 63 68 45 6e 74 69 74 | 79 28 29 20 7b 25 46 6f |achEntit|y() {%Fo|
|00005fd0| 72 45 61 63 68 43 68 69 | 6c 64 52 65 6c 28 29 20 |rEachChi|ldRel() |
|00005fe0| 7b 25 46 69 6c 65 28 27 | 64 3a 5c 70 72 6f 67 77 |{%File('|d:\progw|
|00005ff0| 6f 72 6b 5c 64 65 6d 6f | 5c 76 2d 61 6c 6c 2d 25 |ork\demo|\v-all-%|
|00006000| 50 61 72 65 6e 74 2d 25 | 43 68 69 6c 64 2e 77 27 |Parent-%|Child.w'|
|00006010| 29 7b 25 44 65 63 6c 28 | 69 2c 30 29 26 41 4e 41 |){%Decl(|i,0)&ANA|
|00006020| 4c 59 5a 45 2d 53 55 53 | 50 45 4e 44 20 5f 56 45 |LYZE-SUS|PEND _VE|
|00006030| 52 53 49 4f 4e 2d 4e 55 | 4d 42 45 52 20 55 49 42 |RSION-NU|MBER UIB|
|00006040| 5f 76 38 72 32 20 47 55 | 49 0d 0a 26 41 4e 41 4c |_v8r2 GU|I..&ANAL|
|00006050| 59 5a 45 2d 52 45 53 55 | 4d 45 0d 0a 2f 2a 20 43 |YZE-RESU|ME../* C|
|00006060| 6f 6e 6e 65 63 74 65 64 | 20 44 61 74 61 62 61 73 |onnected| Databas|
|00006070| 65 73 0d 0a 2a 2f 0d 0a | 26 53 63 6f 70 65 64 2d |es..*/..|&Scoped-|
|00006080| 64 65 66 69 6e 65 20 57 | 49 4e 44 4f 57 2d 4e 41 |define W|INDOW-NA|
|00006090| 4d 45 20 43 55 52 52 45 | 4e 54 2d 57 49 4e 44 4f |ME CURRE|NT-WINDO|
|000060a0| 57 0d 0a 26 41 4e 41 4c | 59 5a 45 2d 53 55 53 50 |W..&ANAL|YZE-SUSP|
|000060b0| 45 4e 44 20 5f 55 49 42 | 2d 43 4f 44 45 2d 42 4c |END _UIB|-CODE-BL|
|000060c0| 4f 43 4b 20 5f 43 55 53 | 54 4f 4d 20 5f 44 45 46 |OCK _CUS|TOM _DEF|
|000060d0| 49 4e 49 54 49 4f 4e 53 | 20 56 2d 74 61 62 6c 65 |INITIONS| V-table|
|000060e0| 2d 57 69 6e 20 0d 0a 2f | 2a 2d 2d 2d 2d 2d 2d 2d |-Win ../|*-------|
|000060f0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00006100| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00006110| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00006120| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00006130| 2d 0d 0a 0d 0a 20 20 46 | 69 6c 65 3a 0d 0a 0d 0a |-.... F|ile:....|
|00006140| 20 20 44 65 73 63 72 69 | 70 74 69 6f 6e 3a 20 66 | Descri|ption: f|
|00006150| 72 6f 6d 20 56 49 45 57 | 45 52 2e 57 20 2d 20 54 |rom VIEW|ER.W - T|
|00006160| 65 6d 70 6c 61 74 65 20 | 66 6f 72 20 53 6d 61 72 |emplate |for Smar|
|00006170| 74 56 69 65 77 65 72 20 | 4f 62 6a 65 63 74 73 0d |tViewer |Objects.|
|00006180| 0a 0d 0a 20 20 49 6e 70 | 75 74 20 50 61 72 61 6d |... Inp|ut Param|
|00006190| 65 74 65 72 73 3a 0d 0a | 20 20 20 20 20 20 3c 6e |eters:..| <n|
|000061a0| 6f 6e 65 3e 0d 0a 0d 0a | 20 20 4f 75 74 70 75 74 |one>....| Output|
|000061b0| 20 50 61 72 61 6d 65 74 | 65 72 73 3a 0d 0a 20 20 | Paramet|ers:.. |
|000061c0| 20 20 20 20 3c 6e 6f 6e | 65 3e 0d 0a 0d 0a 2d 2d | <non|e>....--|
|000061d0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|000061e0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|000061f0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00006200| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00006210| 2d 2d 2d 2d 2d 2d 2a 2f | 0d 0a 2f 2a 20 20 20 20 |------*/|../* |
|00006220| 20 20 20 20 20 20 54 68 | 69 73 20 2e 57 20 66 69 | Th|is .W fi|
|00006230| 6c 65 20 77 61 73 20 63 | 72 65 61 74 65 64 20 77 |le was c|reated w|
|00006240| 69 74 68 20 45 52 77 69 | 6e 20 32 2e 36 2e 20 20 |ith ERwi|n 2.6. |
|00006250| 20 20 20 20 20 20 20 20 | 20 20 20 2a 2f 0d 0a 2f | | */../|
|00006260| 2a 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |*-------|--------|
|00006270| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00006280| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00006290| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|000062a0| 2d 2d 2d 2d 2d 2d 2d 2a | 2f 0d 0a 0d 0a 2f 2a 20 |-------*|/..../* |
|000062b0| 43 72 65 61 74 65 20 61 | 6e 20 75 6e 6e 61 6d 65 |Create a|n unname|
|000062c0| 64 20 70 6f 6f 6c 20 74 | 6f 20 73 74 6f 72 65 20 |d pool t|o store |
|000062d0| 61 6c 6c 20 74 68 65 20 | 77 69 64 67 65 74 73 20 |all the |widgets |
|000062e0| 63 72 65 61 74 65 64 20 | 0d 0a 20 20 20 20 20 62 |created |.. b|
|000062f0| 79 20 74 68 69 73 20 70 | 72 6f 63 65 64 75 72 65 |y this p|rocedure|
|00006300| 2e 20 54 68 69 73 20 69 | 73 20 61 20 67 6f 6f 64 |. This i|s a good|
|00006310| 20 64 65 66 61 75 6c 74 | 20 77 68 69 63 68 20 61 | default| which a|
|00006320| 73 73 75 72 65 73 0d 0a | 20 20 20 20 20 74 68 61 |ssures..| tha|
|00006330| 74 20 74 68 69 73 20 70 | 72 6f 63 65 64 75 72 65 |t this p|rocedure|
|00006340| 27 73 20 74 72 69 67 67 | 65 72 73 20 61 6e 64 20 |'s trigg|ers and |
|00006350| 69 6e 74 65 72 6e 61 6c | 20 70 72 6f 63 65 64 75 |internal| procedu|
|00006360| 72 65 73 20 0d 0a 20 20 | 20 20 20 77 69 6c 6c 20 |res .. | will |
|00006370| 65 78 65 63 75 74 65 20 | 69 6e 20 74 68 69 73 20 |execute |in this |
|00006380| 70 72 6f 63 65 64 75 72 | 65 27 73 20 73 74 6f 72 |procedur|e's stor|
|00006390| 61 67 65 2c 20 61 6e 64 | 20 74 68 61 74 20 70 72 |age, and| that pr|
|000063a0| 6f 70 65 72 0d 0a 20 20 | 20 20 20 63 6c 65 61 6e |oper.. | clean|
|000063b0| 75 70 20 77 69 6c 6c 20 | 6f 63 63 75 72 20 6f 6e |up will |occur on|
|000063c0| 20 64 65 6c 65 74 69 6f | 6e 20 6f 66 20 74 68 65 | deletio|n of the|
|000063d0| 20 70 72 6f 63 65 64 75 | 72 65 2e 20 2a 2f 0d 0a | procedu|re. */..|
|000063e0| 0d 0a 43 52 45 41 54 45 | 20 57 49 44 47 45 54 2d |..CREATE| WIDGET-|
|000063f0| 50 4f 4f 4c 2e 0d 0a 0d | 0a 2f 2a 20 2a 2a 2a 2a |POOL....|./* ****|
+--------+-------------------------+-------------------------+--------+--------+
Only 25.0 KB of data is shown above.
